Hcl Technologies 3+ Experienced Sql server Questions

Answer Posted / pasha

How to find sixth highest salary?

--count number of rows first

select count(salary) from employee

select salary from employee where salary=(select max(salary)
from (select top 6 salary from (select top 6 salary from
employee order by salary asc) b order by salary asc) c)

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is placement paper?

2157


Zero setting of sejong rottary press

1201


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

3903


Recently conducted Apptitude test

1413


email me previous question papers of bob bank for po exams

2066






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

790


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

1331


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

3933


why didn't get placed so far?

1198


what is bidirectional?

1396


A frog wants to climb a pole which is 15 feet in height, frog can jump 3 feet every minute after which he rests for a minute where he slips down 2 feet. How much time will the frog take to reach the top of the pole?

609


Danlaw placement questions and answers

1359


printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output

1403


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

1603


What kind of Issues/bugs arise in ETL projects? I would like to know few issues (critical to somewhat bugs ) normally occur in ETL process especially when testing? Domains can be banking, retail or any.

1427