how to get top two salaries from employee tables

Answer Posted / varu

This will be right answer for the query

Select * from empsal e where 2<=(select count(*) from empsal f
where e.sal>f.sal) order by sal desc

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between web based application and client server application?

5704


I have to give weights to 5 stones so that using a simple balance and the stone i should be able to weight any number between 1-100

1952


Please send any one latest 3+ years of experience testing tools resumes my mail id is krishnavenimodaliar26@gmail.com

2961


What is baseline testing?

738


what are the 3 test tool categories and describe what each can do.

2048






Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?

1617


Which criteria should take in account while doing CMS testing of any project?

1399


define risk management system with example ?

1641


What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?

1693


What is reverse engineering?

833


1.what promted you to become involved in QA/Testing?

1839


Explain the difference between alpha testing and beta testing.

735


What is test management?

1517


What are bug leakage and bug release?

858


How do you test google or gmail application??tell me step by step process??

10160