0

Request for GOOD SQL sites the explain Select in Select well with examples

I'm having a really hard time wrapping my head around using this function and when to use it and the logic behind it. For instance: /*Select the code which would show the year when neither a Physics or Chemistry award was given */ I do not understand why it's: Where yr NOT (Select the code which shows the years when a Medicine award was given but no Peace or Literature award was ) AND this query ( /*Select the code which would show the year when neither a Physics or Chemistry award was given */) ...contradicts another question that needs the subjs. separated into two Where clauses. :( HELP, If you have a site that explains the select clauses in great detail with ample examples I would most appreciate it. This is the biggest thing holding me back in SQL.

25th Jul 2018, 5:55 PM
Christina Camacho
Christina Camacho - avatar
2 Respostas
+ 6
Actually, the most common start would be: https://www.w3schools.com/sql/ I have recently found: https://sqlzoo.net to have a more applied approach. Also despite my detest towards teradata SQL, it actually has a pretty good documentation with simple examples: https://info.teradata.com/htmlpubs/DB_TTU_16_00/index.html
25th Jul 2018, 6:09 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
0
SELECT code FROM table_name WHERE award NOT LIKE '%physics' AND award NOT LIKE '%chemistry';
4th Aug 2019, 5:22 PM
Ojo Olasehinde Itunu
Ojo  Olasehinde Itunu - avatar