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
how to increment dates by 1 in mysql? : Sql dba
What is varchar sql?
what are the features and advantages of object-oriented programming? : Sql dba
How do I run pl sql in sql developer?
How do I edit a stored procedure?
Name the different types of indexes in sql and define them.
How do I kill a query in postgresql?
how to select first 5 records from a table? : Sql dba
When to use inner join and left join?
What is dml and ddl?
Is subquery faster than join?
discuss about myisam index statistics collection. : Sql dba
What does closing a cursor do?
What is crud stand for?
Which nosql database is best?
