In What order will the output be sorted?
SELECT * FROM TABLE1 ORDER BY ID, NAME DESC;
a) sort descending on NAME then descending on ID
b) sort ascending on ID then descending on NAME
c) sort descending on NAME then ascending on ID
d) sort descending on ID and descending on NAME
Solution: b)
SELECT * FROM TABLE1 ORDER BY ID, NAME DESC;
a) sort descending on NAME then descending on ID
b) sort ascending on ID then descending on NAME
c) sort descending on NAME then ascending on ID
d) sort descending on ID and descending on NAME
Solution: b)
No comments:
Post a Comment