PHP ZCE mock test, interview preparation, daily lessons under chalk talk

Wednesday, May 2, 2012

Mysql Sorting Order?

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)

No comments:

Post a Comment