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
- 8967 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 decision table testing?
What is remedy testing,expalim that and how can use that
what types of bugs will we find out in banking projects
Do we have any certifications for ETL Testing ?
What is the difference between web based application and client server application?
Name three reasons why the tester may choose to record in Context Sensitive mode.
ANY ONE HAS ATTENDED THE INTERVIEW FOR WIT INNOVATION P LTD? THEN KINDLY LET ME KNOW ABOUT THE INTERVIEW PROCESS AND QUESTIONS ASKED.
what is a data guidelines?
what is the critical defect in telecom domain?help me out from this prob its very urgent
What is the purpose of test strategy?
how will we change the server system time?
How many bugs occured will be considerd appropriate over 1000 steps when inspecting software? Describle an approriate Bug value.
what is the function generator?
How to overcome pesticide paradox?
What is sanity?
