Downloaded 39 times
Uploaded bySrinimf-Slides
100 sql queries
The document provides SQL query examples demonstrating the use of joins, including inner and left outer joins, as well as subqueries. It includes a table structure showing employee names and job titles alongside their IDs. Additionally, it references a resource for downloading 1000 SQL queries from the website srinimf.com.
More Related Content
100 sql queries
- 1.
- 2. Join Example EMP_NM EMP_JBSELECT nm.id ANSWER +----------+ +--------+ ,nm.name ================ |ID|NAME | |ID|JOB | ,jb.job ID NAME JOB |--|-------| |--|-----| FROM emp_nm nm -- ------- ----- |10|Sanders| |10|Sales| ,emp_jb jb 10 Sanders Sales |20|Pernal | |20|Clerk| WHERE nm.id = jb.id 20 Pernal Clerk |50|Hanes | +--------+ ORDER BY 1; +----------+
- 3. Left Outer Joinexample EMP_NM EMP_JB SELECT nm.id ANSWER +----------+ +--------+ ,nm.name ================ |ID|NAME | |ID|JOB | ,jb.job ID NAME JOB |--|-------| |--|-----| FROM emp_nm nm -- ------- ----- |10|Sanders| |10|Sales| LEFT OUTER JOIN 10 Sanders Sales |20|Pernal | |20|Clerk| emp_jb jb 20 Pernal Clerk |50|Hanes | +--------+ ON nm.id = jb.id 50 Hanes - +----------+ ORDER BY nm.id;
- 4. Sub Query Example EMP_NMEMP_JB SELECT * ANSWER +----------+ +--------+ FROM emp_nm nm ======== |ID|NAME | |ID|JOB | WHERE NOT EXISTS ID NAME |--|-------| |--|-----| (SELECT * == ===== |10|Sanders| |10|Sales| FROM emp_jb jb 50 Hanes |20|Pernal | |20|Clerk| WHERE nm.id = jb.id) |50|Hanes | +--------+ ORDER BY id; +----------+
- 5. Thank you Download 1000 SQLQueries here Srinimf.com