COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Sale TableSALEID SID SLDATE1001 1 01-JAN-141002 5 02-JAN-141003 4 01-FEB-141004 1 01-MAR-141005 2 01-FEB-141006 1 01-JUN-15Display the sale id and date for most recent sale.
|
|
SELECT SALEID, SLDATE FROM SALE WHERE SLDATE=(SELECT MAX(SLDATE) FROM SALE);
|
|
|
SELECT SALEID, SLDATE FROM SALE WHERE SLDATE=(SELECT MIN(SLDATE) FROM SALE);
|
|
|
SELECT SALEID, SLDATE FROM SALE WHERE SLDATE=(SELECT AVG(SLDATE) FROM SALE);
|
|
|
None of the above
|
Explanation:
There is 1 question to complete.