retrieve a last value from sql

[Ahmedhussain]

Hi,
Can any one tell me .. How to retrieve a last value from the database?
I tried the last function, but I just got the error.

Thanks in advance

Regards,
Syed Ahmed Hussain

[ziycon]

Could try the below, not sure if it works in SQL though.

SELECT MAX(column) FROM tablename

[Jerry Winston]

Correct me if i'm wrong, but do you mean last row entered into a table?

SELECT MAX(MySequentialIndexColumn) from [MyTable]

works based on the premise that MySequentialIndexColumn is an IDENTITY column continuously incremented with each addition to the table. Therefore, the highest value of the column should be the latest entry.

Here's my advice:

If it is important to know when a row was added to a table the time/date of insertion should be listed as a field. With the addition of a time/date field, you will be able to query your table based on the exact time rows were entered.

[Ahmedhussain]

Both of you are right....

Thank you guys.. :)

Regards,

Syed Ahmed Hussain

[OuTCasT]

If you have an identity column then u could use

select @@Identity from myTable

[Ahmedhussain]

So what will this query do?

select @@Identity from myTable

[OuTCasT]

if u have and identity column which set ur rows in order 1 2 3 4 5 etc
then it will pull the last value inserted in the database.

i add a index column like so

alter table MYTable
Add TempID int IDENTITY(1,1)