select max(column name) from table_name where((select max (column name) fr

Write a query to find second highest salary of an employee.

Question Posted / vidhya

72 Answers
128353 Views
ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
E-Mail Answers

Answer Posted / vidhya

select max(column name) from table_name where((select max
(column name) from table_name Order by salary Desc) set
difference (select max(column name))

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Elaborate the fields in bug report in automated testing

992

In Selenium how a test suit is run and report is generated.

2049

What is build verification testing, bvt?

1116

What is the process of Automation Testing?

1125

Can any one give information on "Content Disposition" in TEST COMPLETE automation tool? mail me to pdamarakonda@smart-bridge.co.in call me to 09849423932

2056

How to check if an element is visible on the page?

970

Differentiate between hdam and hidam database?

960

Tell me what is tsl? What 4gl is it similar too?

1030

did anybody take online training from Mind Q systems hyderabad? please share your experience. thanks

2185

Bug report formate in bugzilla

2073

What java api is required for generating pdf reports?

993

Explain what sikuli is?

1058

List the five essential types of test steps?

1150

What are the pre-requisites to start automation testing?

963

Can we do automation testing without a framework? If yes, then why do we need a framework?

1198