Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Display last 10 records

Author  Topic 

harshilshah
Starting Member

8 Posts

Posted - 2012-12-26 : 05:44:54

I have some 70 database entries in table weight

weight
------
45.6
45.34
23.56
.
.
.
...
.....
....
66.78
34.67
78.99

I want to display the last 10 entries. Can any1 help me with the query.IM woeking with sql 5.5

harshilshah
Starting Member

8 Posts

Posted - 2012-12-26 : 05:46:34
SELECT * FROM TableName LIMIT 10;
this query displayed top 10 records. I want last 10 records..
Go to Top of Page

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-26 : 06:30:24
quote:
Originally posted by harshilshah

SELECT * FROM TableName LIMIT 10;
this query displayed top 10 records. I want last 10 records..


Duplicate: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181693


Follow MySQL related forums like
www.dbforums.com
http://forums.mysql.com/

--
Chandu
Go to Top of Page
   

- Advertisement -