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
- 8009 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
What is the web service used for reporting services?
Explain in brief about Microsoft SQL server?
What do you understand by integration services in sql server?
How does the report manager work in SSRS?
What is global temp table?
What do you understand by triggers and mention the different types of it?
Ways to improve the performance of a SQL Azure Database?
What is a covered index?
What is the difference between left and right outer join?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What do you understand by physical_only option in dbcc checkdb?
Can you explain powershell included in sql server 2008?
What are the steps to insert a table?
What the class forname () does?
How to convert a numeric expression from one data type to another?
