sql command

[miladhatam]

hi
how can i select last 5 fields of my table
i don't know it sql command

 

[Alexey Smirnov]

hi
how can i select last 5 fields of my table
i don't know it sql command

SELECT field6, field7, field8, field9, field10 FROM mytable

 

[miladhatam]

sorry alexy
oh i made a mistake i want to select 5 last records
sorry ...
have any idea ?
thanks

 

[Alexey Smirnov]

sorry alexy
oh i made a mistake i want to select 5 last records
sorry ...
have any idea ?
thanks

SELECT TOP 5 * FROM mytable ORDER BY something DESC

where "something" is a name of the field which used for a consecutive
values like rowid, date created, etc...

 

[Juan T. Llibre]

Is there a date-of-record field ?

select top 5 * from yourtable order by datefield desc




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================

 

[miladhatam]

thanks alexey
like every time you helped me