what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
Answer Posted / veeresh kethari
with Topsal (EmpID,Ename,Sal,Dno,Topsal) as
(select *,row_number() over(order by sal) Topsal from emp)
select top 2 EmpID,Ename,Sal,Dno from Topsal order by sal desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is advantage data architect?
how many no of arguments can be passed in procedures and functions
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What is filtered index?
How to search for a string in all stored procedure in sql server?
Explain log shipping and mention its advantages.
What are the different types of normalization?
Explain about system stored procedure?
how can you attach more than 20 ldf files in sql server
How to retrieve error messages using odbc_errormsg()?
What are pessimistic lock and optimistic lock?
What is bit data type? What's the information that can be stored inside a bit column?
Is it true, that there is no difference between a rule and a check constraint?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is the difference between a primary key and a unique key? Are they the same?