Hcl Technologies 3+ Experienced Sql server Questions

Answer Posted / susmita

6. HOW TO FIND 6TH HIGHEST SALARY?




with ta
as
(
select distinct top 6 salary from tblemp order by salary desc
)
select min(salary) from ta

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what you will do when you struck in traffic ?

1051


your project to describe and tell about : 1. My favorite things 2. My favorite places at home 3. Animals *Choose one of them to describe *Write on your paper *If you done, Send me *Did you get it

784


what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region

1593


Danlaw placement questions and answers

1356


Hi.. Guys Im pranitha, presently im working in a organisation & im look for job at MNC's like DELL, Delloitte, Bank of America, Genpect, etc., I have completed B.com . Pls help me...

1147






What are the frequently asked questions for interview in capital iq company ?

1324


Do we have vacancy for HR RECRUITER ?

1380


what is placement paper?

2151


HI SIR I WANT PREVIOUS QUESTION PAPER OF HPCL I M CHEMICAL ENGG.

1945


my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef abc*$#1___ cdef____ghi a_z_k_h___ 4_3_2_1___ ______5678 output file: 8765_____ 1_2_3_4__ h_k_z_a__ ihg____ghi 1#$*cba__ fedcb4321

1194


speak 1min on topic Travelling,memorable moment ,memorable day?

1740


If anybody knows the recruitment procedure of IOTL & POWER MECHANICAL. send me the placement papers if u hav... very urgent ...

3894


i want the sample placement paper of goldman sachs urgently. please send it to me

3926


how did you celebrate your last birthday?

1275


What were the occupations of the people who lived within the Mauryan Empire?

581