select top 1 from (select top 2 from emp order by sal desc)A order by sal

write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")

Question Posted / suresh miryala

6 Answers
20623 Views
Bally Technologies, Cognizant, Vertex, I also Faced
E-Mail Answers

Answer Posted / suresh miryala

select top 1 from (select top 2 from emp order by sal desc)A
order by sal

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the syntax for plist?

1129

how you get the relative record in a subfile in which cursor is located?

1111

What is diff between EVAL & MOVE?

1586

how can I control the way a remote browser uses its cache?

1219

What is RETURN CURSER LOCATION in subfile?

1578

what is the sequence when using cursor?

1229

any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

1717

how will you find a string using pdm?

1157

Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?

2599

Difference Between Source Physical File & Physical File?

1088

how can I control from my cgis the cache of a remote browser?

1173

is there any way to dynamically merge other html scripts into a given html?

1081

in which specification the report layout can be defined?

1640

what are dds required for subfile?

1049

what is the function of crtdupobj command?

2086