SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Display last 10 records
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

harshilshah
Starting Member

India
8 Posts

Posted - 12/26/2012 :  05:44:54  Show Profile  Reply with Quote

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

India
8 Posts

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

bandi
Flowing Fount of Yak Knowledge

India
2223 Posts

Posted - 12/26/2012 :  06:30:24  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000