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 a database? : Sql dba
Can you rollback after commit?
Can function return multiple values in sql?
How do I install sql?
How do you update f as m and m as f from the below table testtable?
Which constraints we can use while creating database in sql?
What is pragma in sql?
Can primary key be changed?
Is pl sql and postgresql same?
What is sql exception?
Why do we use joins?
What are inner and outer joins examples of both?
Is microsoft sql free?
Which sql most popular?
Which sql statement is used to delete data from a database?
