-
Need Query
Hi all ,
I am ram , i want to find the fifth maximum value . please how to make a simple query for this
-
Try this:
select top 1 * from (select top 5 * from Table1 order by col1 desc) as a order by col1
-
Query is not working
Hi,
Thank u for to send the query , but the query is not working . showing syntax error
-
Can you post your query? Did you run your query on sql server?
-
Need Query
select top 1 * from ( select top 5 * from tbltest order by tdnum desc ) as a order by tdnum
i run this query in MySql
-
This is sql server forum so the query I gave is t-sql. Post your issue in MySQL forum.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|