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
- 9200 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
need answer interviewer will ask me about all project which i mention in resume or presently i'm working??please reply tomorrow is my interview
Give the real-time example for back-to-back testing?
What is desk checking and control flow analysis
What are the typical risks that you identify during test planning and their mitigation plan and Contengency plan.
Which is the best book to ref. for design the test cases/scenario in manual testing,which gives detailed idea with all the strategies ?
What are the interview question on insurance domain in manual testing
Can any1 tell me suppose u r doing manual testing on unix platform with Shell Script, then how it is done? How u r implementing it & what is the use of Shell scripting on Manual Testing?
Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.
how to test a web application manually?can u explain indetail?
What is defect cascading in software testing?
What are cookies?
What impact ratings have you used in your projects?
How do i write a test condition to test the following simple program with the intention of 100% statement coverage Print “Hello World” If Date $ = ‘01-01-2000’ then Print “Happy New Year” END IF PRINT “The date is = “Date $ PRINT “The time is = “Time $ END Could anyone please clarify in detail. Would really appreciate it....
What is the main use of preparing a traceability matrix?
whats the reason to display the password(not in encrypted form) in the script in load runner but not in QTP?
