Question : I wonder if there is an equally elegant solution for Oracle for the problem posted and answered here: […]
Tag: minus
Oracle: finding rows without children in a table with a foreign key?
Question : Suppose I have two tables with a foreign key relationship. How can I find the rows in the […]
How to select students that failed at least at all courses that student with id = 1 failed?
Question : I have the following tables: STUDENT (student_id, first_name, last_name, birth_date, year , domain) PROFESSOR (professor_id, first_name, last_name, birth_date, […]
ORA-00907: missing right parenthesis on query with subqueries and EXCEPT operator
Question : I am getting ORA-00907: missing right parenthesis for the following query: SELECT PEOPLE.NAME FROM CLIENTS K INNER JOIN […]
How to select students that failed at least at all courses that student with id = 1 failed?
Question : I have the following tables: STUDENT (student_id, first_name, last_name, birth_date, year , domain) PROFESSOR (professor_id, first_name, last_name, birth_date, […]
Select items that have never been ordered using the MINUS operator
Question : I have the following two tables: ITEM (Item#, Item_Name, Unit_Price) ORDER_ITEM (Order#, Item#, Qty) Now, how do I […]