Problem I am a beginner in Access SQL. I am in need of writing a parameter query for Access SQL […]
Tag: sql
Selecting all posts with a certain tag
Problem The task is to select all posts tagged with a certain tag, along with other tags the post may […]
Program for entering 1000 random numbers into two different databases, one for odd numbers and one for even
Problem I have created a program in java for entering 1000 random numbers into two different database one for odd […]
Creating SQL queries for a MySQL database
Problem I am writing a PHP application that works with a MySQL database. As I am fairly new to PHP […]
Find occurrences of strings in view B in column from table A
Problem I’m trying to find the occurrences of strings in view B in a string in table A. However, the […]
High school social network query for friends in common
Problem This is sourced from the Stanford Coursera self study DB class SQL quizzes: Students at your hometown high school […]
Registration and login script
Problem This is a registration and login script I have made in Python 3. It uses a MySQL database. In […]
Converting recordsets to POCO
Problem The goal this method was to emulate the way EF or Dapper return to you concrete POCO classes instead […]
Enforcing a constraint that a user may vote on each post at most once
Problem I have the following table in a PostgreSQL database: creator uuid not null, post uuid not null, type text […]
Song database query
Problem I am relatively inexperienced with MySQL and have a query, which to my eyes appears relatively complex: SELECT SQL_CALC_FOUND_ROWS […]