how to get top two salaries from employee tables
- 12 Answers
- 21750 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sivaprasad
SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2
SALARY FROM EMP ORDER BY SALARY DESC.
OR
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is reverse engineering?
how can u prepare the test plan?
How much the bug is affecting the functionality of the application?
What is the Difference between Network testing and Web Testing?
how will we change the server system time?
What is the difference between coupling and cohesion?
what are metrics and what are metrics did u collect in you are project
Hello, I want to know how to write a regression test plan? Can someone please send me the format/template? Thanks in advance
I have interview on Guide wire testing. If you please share me.
tell me brief about your project? please help me how to explain the project what is the flow? my current project is ERP domain web based application. please help me
Hi, Can anyone suggest a test case writing technique for the below scenario. 1. User draws a lines on the image 2. User selects the lines and right clicks ( Measuremnts like distance between the start and the end point, coordinates of start point and coordinates of end point) 3. User selects one of the measurement Measurement is displayed Just want to highlight, i am looking for a test case writing technique for above scenario.
how many modules in ur bank project? what functionalities r there?how did u check? could u plz expalin ur banking project?
Which are the standards for software test plans?
can anyone tell me the questions that can be posed in an interview for a 5 year experienced person in manual testing
What are tools of performance testing?
