Answer Posted / bunty
IN - used to select multiple rows based on any of the key
provided
SQL - select distinct employeeid from orders where orderid
in ( select orderid from orderdetails where discount >= 10)
ANY - used in case of relational queries to compare result
with any of the key.
SQL - select custID from orders where regionID != "E" and
discount > any (select discount from orders where regionID
= "E" and discount > 3)
ALL - used in case of relational queries to compare result
with all of the keys.
SQL - select custID from orders where regionID != "E" and
discount > all (select discount from orders where regionID
= "E" and discount > 3)
Cheers -
Bunty
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
what is self join and what is the requirement of self join? : Sql dba
How do I filter in sql profiler?
How can you know that statistics should be updated?
What is the use of partition by in sql?
What is sql trigger example?
What is pls_integer in pl sql?
What does pl sql developer do?
What is sql in oracle?
what is the command used to fetch first 5 characters of the string? : Sql dba
Can we use delete in merge statement?
how to create a table index in mysql? : Sql dba
What is a unique key and primary key and foreign key?
What do you mean by dbms? What are its different types?
Which sql statement is used to return only different values?
Explain aggregate functions are available there in sql?
