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
- 9222 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 smoke testing and what is sanity?
how to connect your project in database?
hi what are the test cases for web application..i need these example..please..mail me at mina_ims@yahoo.com
Explain the strategy for testing a Java application?
whta is compile module?
What is white box testing, and what are the various techniques?
What is middle ware testing?? what are the companies using this tech?
How to explain a banking project in interview ? like project discription is Client Online Banking Application provides access to information relating to Banking Online Services provided by Axis to View daily customer transactions, Current and Previous customer statements, Transfer funds from Chequing and Savings accounts ................ From interview point of view can any one explain this project in laymans language
What is the difference between load testing and performace testing?
What is your approach when requirements change continuously?
Plz give me manual testing real test case ?
i want to for technical interview question paper along with in tesrviwe Phases i need
Hi I am searching job please send some details abuot ERP project and real time test plan,traceability report,test case if any relate to erp project Please help me out to get a job in testing.my email address is chiku_69@yahoo.in Thank u
What is bug, deffect, issue, error?
What is the Difference between Network testing and Web Testing?
