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.

Expand|Select|Wrap|Line Numbers

SELECT MAX(column) FROM tablename

b0010100

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

Expand|Select|Wrap|Line Numbers

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

Expand|Select|Wrap|Line Numbers

select @@Identity from myTable

Ahmedhussain

So what will this query do?

Quote:

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

Expand|Select|Wrap|Line Numbers

 alter table MYTable

Add TempID int IDENTITY(1,1)

retrieve a last value from sql

re: retrieve a last value from sql

re: retrieve a last value from sql

re: retrieve a last value from sql

re: retrieve a last value from sql

re: retrieve a last value from sql

re: retrieve a last value from sql

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about