how to get top two salaries from employee tables

Answer Posted / shiva - e-softsys

SELECT MIN (SALARY) FROM EMP WHERE

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY
SALARY DESC)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi guys,I have 3+ years of exp in manual testing in a bangalore based MNC company.I Like to jump in chennai.So please if u know any jobs in chennai firms please let me know in my email-id. anbarasu2k@rediffmail.com. cheers, anbarasu.

1461


What is the difference between functional requirement and non-functional requirement?

662


Can you explain an application boundary?

639


send the senario template

1486


tell me 5 new requirements in ur project? plz urgent

1958






Is an "A fast database retrieval rate" a testable requirement?

1512


hi this is ashok , i never worked in medical domain , can any one pls send me with proper exaple pls Question is while emergency or normal patitent enter into hospital he entered his first and last name and he enter emergency coloumn , write test case on these ,

1604


Assume a login page, and you have written 10 cases(say for example). How will you justify that these 10 testcase suffient for the login and how do you say this is 100% satisfies the need.

1717


what is the difference between test case and result matrix

1680


How can you do the usability testing?

713


1. Give me an example of something you tried at work but did not work out so you had to go at things another way. can somebody give a real time example

1881


what is data guidelines

1629


What is reverse engineering?

734


What is the difference between static testing and dynamic testing?

643


Which test cases are written first: white boxes or black boxes?

786