whenever i write ORDER BY clauses, i generally specify ASC or DESC after the field i am ordering by...
eg
SELECT *
FROM Table
ORDER BY TableID DESC
the thing is, when i get to typing ASC or DESC, rather than just having these options, i seem to be presented with every field in the database that starts with DESC (such as description). Would be nice if it were smart enough to know the only options for order by are ASC or DESC
thanks
Ben
eg
SELECT *
FROM Table
ORDER BY TableID DESC
the thing is, when i get to typing ASC or DESC, rather than just having these options, i seem to be presented with every field in the database that starts with DESC (such as description). Would be nice if it were smart enough to know the only options for order by are ASC or DESC
thanks
Ben