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
- 7299 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
Tell me a critical defect in which your Client,PM,PL appreciate on you
What is Mixed Testing
value momentum
In usability testing we check spelling, content, look and feel, color combination, link or menu navigation? please let me know more about usability testing.
i want to for technical interview question paper along with in tesrviwe Phases i need
what are your thoughts on SPRINT duration
Am putting E-commerce project in my resume can any one please tell me about E-commerce application explaination..
online demo for bug tracker tool(let me know the website)
HI FRNDS, I HAVE 2.5 years OF exp In Manual Testing,Plz let me know if thr r any oppurtunities in any company in Bangalore ID:dsnithi@gmail.com Thanks in Advance
What is fuzz testing?
Tell me agile process in your company
How to test the search functionality.For example in naukri advance search is there.how ca i test that page.
Hi Frnds, this is Aman.. can anybody tell me plz what kind of QA Interview questions are asked by IDS Infotech Ltd., Chandigarh? I have lil bit experience only in Manual Testing.. Plz answer my question as soon as possible.. Thnx in advance..
How quickly we need to fix the bug?
Please let me know how to test labels in web application manually and how the testcases would be. Please provide me a sample testcase
