how to find nth highest salary
Answer Posted / gopi mandadi
Select emp_no,name,dept,sal from emp_t A
Where &n = (Select sal from emp_t B Where A.sal <= b.sal)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Mention what are the different types of ssrs reports?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How to write a query with a right outer join in ms sql server?
What is SQL Azure?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How do I port a number to sql server?
How many primary keys are possible in a table?
What are the rendering extensions of ssrs?
What are functions in the sql server?
What is user-defined function?
What is page in sql server?
How to list all schemas in a database?
What are commonly used odbc functions in php?
How to enter binary string literals in ms sql server?