There's No Place Like 127.0.0.1


SQLDatabases


VIEW SOURCE CODE BACK TO CATEGORIES







Up down arrows


SQL Code

SQL and Relational Database Management Systems


Find all my SQL code here. Syntax may vary depending on the type of RDMS I'm referring to but I will make it clear as to the type being used. SQL syntax variations will include the following: Oracle, MySQL, Microsoft SQL, Maria, SQLite, PostgreSQL and a variety of NOSQL and document oriented databases.

If you have any questions or suggestions send me a message.

Remember, to force a browser cache refresh and reload any page press Ctrl + F5. Or hold down Shift + Reload .

divider
1.0 SQL Sub Queries

Sub queries with relative comparison operators.

Main Class
    
SELECT * FROM score
WHERE event_id =
(SELECT event_id FROM grade_event
   WHERE date = '2012-09-23' AND category = 'Q');
    
Up Arrow