need to write sql select last row of table

[ssala]

i have a table contain 1000 of records. I need to display last row of the table.

please let me know how to do it in SQL. I tried all Select statement but could not get it. I can count total rows with Select Count(*) from Table; but how to get the last row.

 

[johnwm]

What do you mean by 'last'? SQL does not define the order that data is stored in a table. If you have a Datestamp field, or a serial number field then you could use something like:
Select Top 1 myName, myID from myTable Order by myID DESC

See the TOP predicate in SQL books on line, downloaded from:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[ssala]

thanks that helped.

 

[rtmpxr]

Very simple (it depends what SQL engine are you using):

Firebird
select FIRST 1 from <your table> order by <field> DESC

Access
select TOP 1 from <your table> order by <field> DESC

If you are using else, search for something equivalent in it's sql language reference (for example Interbase has ROWS clause)

 

[johnwm]

Is there an echo in here?

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[rtmpxr]

Right, is it one?