Hello.
I need to tell my script to open a Database and to read stored informations only from the record with the highest ID. Example: I have 7 records whose ID go from 1 to 7, I need to open only the last one (ID7). How can I do this ?!

THANKS

Following are some of the possible ways:

1. select * from your_table where Id = (select max(ID) from your_table)

2. select top 1* from your_table order by ID desc



Om Prakash

As usual , thanks so much Mr.Prakash !