Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Regarding Sql server

4 Posts 2 Posters 0 Views 1 Watching

P Offline
P Offline
Praveen029

wrote on last edited by

#1

Hi, Please send me how to get last 10 records in a table( There is no index on table)
B 1 Reply Last reply

0
P Praveen029

Hi, Please send me how to get last 10 records in a table( There is no index on table)
B Offline
B Offline
Blue_Boy

wrote on last edited by

#2

select top 10 * from tablename order by [id] desc

I Love SQL
P 1 Reply Last reply

0
B Blue_Boy

select top 10 * from tablename order by [id] desc

I Love SQL
P Offline
P Offline
Praveen029

wrote on last edited by

#3

Hi I mean to say newly inserted records. i.e Suppose a table have 1000 records.I need to retrieve 991 to 1000 records.
B 1 Reply Last reply

0
P Praveen029

Hi I mean to say newly inserted records. i.e Suppose a table have 1000 records.I need to retrieve 991 to 1000 records.
B Offline
B Offline
Blue_Boy

wrote on last edited by

#4

If you have column named ID which is autonumber then my query which i posted before works

I Love SQL
1 Reply Last reply

0

Log in to reply