[thelist] Quick SQL question

Rob Smith rob.smith at THERMON.com
Mon Feb 10 14:40:00 CST 2003


Hi,

I want the last 15 or so records from my table, so I try this:

SELECT   TOP 15 *
FROM     MyTable
ORDER BY Col_ID DESC

but this returns

255
254
253
252
251

I want it to return

251
252
253
254
255

Do I smell nested queries?

Rob.Smith



More information about the thelist mailing list