how to find nth highest salary
Answer Posted / ajay kumar barik
select a.id from product a where (1= (select count(b.id)
from product b where b.id>=a.id))
It is for all database
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
State a few properties of relational databases?
What are 3 ways to get a count of the number of records in a table?
What's new in sql management studio for sql server? : sql server management studio
What is a trigger? Why we need it?
Does sql server 2016 have ssms?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are the different kinds of ssrs reports?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is function of CUBE ?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to create a new schema in a database?
What are the advantages of sql stored procedure?
Can we deploy SSRS reports on our personal website?
How do I create a trace in sql server?