posted 15 years ago
select BUYERID,ITEM FROM ANTIQUES WHERE PRICE >= ALL
(SELECT PRICE FROM ANTIQUES);
Question: What would be the output of the [preceding] query?
A) Gives the least priced item
B) Gives the largest priced item
C) Gives both largest and least priced items
D) No rows
[edit]Get rid of the worst of the CAPITAL letters. CR[/edit]
[ July 11, 2008: Message edited by: Campbell Ritchie ]