Guest Gaurav Garg Posted November 9, 2006 Share Posted November 9, 2006 Hi I have stuck with this problem please help me outIn my Application i want to select last 10 records from the table or ucan say from the inner queryi don't know how to do that please anyone do tell me the solution for this.. Link to comment Share on other sites More sharing options...
jteixeira Posted November 9, 2006 Share Posted November 9, 2006 Select top 10 Column,Count(*) From Tabel Group by ColumnOrder by count(*) DESC Link to comment Share on other sites More sharing options...
aspnetguy Posted November 10, 2006 Share Posted November 10, 2006 SQL Server SELECT TOP 10 *FROM tableNameORDER BY primaryKey DESC MySql SELECT *FROM tableNameORDER BY primaryKey DESCLIMIT 10 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now