Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20386 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 the distinction amongst delete and truncate?
What happens if ntwdblib.dll is missing on your machine?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
what are the disadvantages of cursors? : Sql server database administration
What do I need to start working with sql studio? : sql server management studio
what's the difference between a primary key and a unique key? : Sql server database administration
Can a function call a stored procedure in sql server?
What is sql server 2000 work load governor?
What does it mean to be in union?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How dts is used to extract, transform and consolidate data?
What are the operating modes in which database mirroring runs?
What is cached report?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is a dataset and what are the different types of datasets?
