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
- 8365 Views
- I also Faced
- E-Mail Answers
Answer Posted / kb
select top 1 * from emp
where sal < (select max(sal)from emp)
order by sal desc
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to convert character strings into numeric values?
Disadvantages of the indexes?
do you know how to configure db2 side of the application? : Sql server database administration
What are wait types?
What is in place upgrade in sql server?
What is subquery? Explain the properties of a subquery?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to convert numeric expression data types using the cast() function?
Is it possible to have clustered index on separate drive from original table location?
How do I find the sql server version?
What is sql server query analyzer?
Explain system functions or built-in functions? What are different types of system functions?
What is a coalesce function?
List the ways in which dynamic sql can be executed?
What is normalization and what are the advantages of it?
