Interested to Buy Any Domain ? << Click Here >> for more details...
An employee table, with the columns id, name, sal and
dob.Query to select emp names of all highest salaries(there
are 4-5 people having the same salary which happens to be
the highest).
- 5 Answers
- 9036 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / naveen kamatam
select ename, salary from emp e
where 4 > (select count(distinct salary)from emp where
Salary > e.salary)
it will fetch top 4 high salary records
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is actually a rule based testing
how recovery manager works in winrunner
What type of testing you perform in organization while you do system testing, give clearly?
what is the difference between Desktop testing,Client/server testing and webapplication testing
How do you test google or gmail application??tell me step by step process??
What will be the QA roles and responsibilities in Health care stream like BCBS,can someone please explain me any example project regarding health care services in web-based application?
qtp9.2 and qtp10.0 difference
how to indentify memory leakages after the build
What is user acceptance testing (uat)?
What is difference between Build, Version and Release
how many modules in ur bank project? what functionalities r there?how did u check? could u plz expalin ur banking project?
What is a testbed in manual testing?
can anyone tell me the questions that can be posed in an interview for a 5 year experienced person in manual testing
What is checkpoint? How can you handle the checkpoints?
What is smoke testing and what is sanity?
