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
what is difference between uv and visible spectroscopy and how to differentiate the drug compounds in uv visible region
my question is : reverse a string in COBOL program (please write a code asap) input file: 1234abcdef output file: 8765_____ abc*$#1___ 1_2_3_4__ cdef____ghi h_k_z_a__ a_z_k_h___ ihg____ghi 4_3_2_1___ 1#$*cba__ ______5678 fedcb4321
i want the sample placement paper of goldman sachs urgently. please send it to me
how did you celebrate your last birthday?
Recently conducted Apptitude test
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?
what is bidirectional?
what is the use of air in gc
Do we have vacancy for HR RECRUITER ?
printf("%d",printf("%d",printf("%d",printf("%s","ILOVECPROGRAM")))); whats the output
speak 1min on topic Travelling,memorable moment ,memorable day?
HI SIR I WANT PREVIOUS QUESTION PAPER OF HPCL I M CHEMICAL ENGG.
email me previous question papers of bob bank for po exams
Danlaw placement questions and answers
Zero setting of sejong rottary press