[Question] Query For Tables

01/24/2015 07:00 Little Messi#1

i want a query to get the last lines or ID added in the table

01/24/2015 07:07 Snow*#2

[Only registered and activated users can see links. Click Here To Register...]
order by ColumnName

01/24/2015 07:12 Little Messi#3

why don't u just give a straight answer, i wouldn't be posting here if i can't find it any where else -_-

01/24/2015 09:46 Exo#4

What kind of ID?

If it's an ID that increases on each insert then obviously the last ones are the bigger ones

01/24/2015 11:33 Zodiao#5

Code:

SELECT TOP 1 * FROM TABLE_NAME order by [ID] desc