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
- 7697 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
i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.
What is manual testing and what is it process?
What is AGP?what is setup.inf?What are the ways to install driver?
Artifacts in design phase of SDLC ?
Please anyone give answers for all below questions and help ? realtimers please and please share your knowledge.lot of questions left unanswered.
Test cases have written according to Flow of the software working or according to Screens?
1. what is baseline document , can you say any two ?
What type of testing you perform in organization while you do system testing, give clearly?
write test case for linked in sign up page ?
what are risks and contigencies(solutions) of an ecommerce (online shopping and bidding project)application?we describe this in Test plan can anyone tell me abt this?
I have an UI issue "please fill out this field" pop up in firefox browser keeps scrolling with the page is it valid???
Can you please explain me how to do testing of an E-insurance project end to end process..
What are the advantages of black box testing?
Explain some techniques for developing software components with respect to testability.
What is client server application testing?
