Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 19788 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / anjum
SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is spatial and temporal data?
What is correlated subquery in sql server?
What are the purpose of Normalisation?
How to Check if table exists in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
can we have a nested transaction? : Sql server database administration
What is the maximum size of a dimension? : sql server analysis services, ssas
Why use view instead of a table?
What are the difference between clustered and a non-clustered index?
Why should one not prefix user stored procedures with ‘sp_’?
How to download and install microsoft .net framework version 2.0?
How can we determine what objects a user-defined function depends upon?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is a Join and explain its types?
How to access the inserted record of an event?
