Interested to Buy Any Domain ? << Click Here >> for more details...
Find 2nd Highest salery in emp table
Select* from emp where &n=
select * count from emp where (salery >=emp.salery)
Enter n value 2
These query is correct or not. Tell me any other methods.
- 6 Answers
- 7835 Views
- I also Faced
- E-Mail Answers
Answer Posted / asimananda
SELECT MAX(SAL) FROM EMP WHERE SAL < ( SELECT MAX(SAL) FROM
EMP )
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
explain different levels of normalization? : Sql server database administration
What is user-defined function?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What are truncate options available in sql server? : sql server database administration
Is it possible in sql table to have more than one foreign key?
Working with TLogs
What is function of CUBE ?
What are sparse columns?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is a rownum?
What are security principals used in sql server 2005?
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
How does index makes search faster?
What is the difference in accessing db between sql server vs sql azure?
What are examples of triggers?
