It is a SQL question. Write a query to find top three
salaries in an EMP TABLE?
- 7 Answers
- 12503 Views
- I also Faced
- E-Mail Answers
Answer Posted / ruchi
In MYSQL:
select salary from (select salary from tbl_salary t order
by salary desc) as u limit 3;
u is the table alias,which is a must.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
why should we give deliver good quality software?
i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet
What is Test Fusion Report in QTP?
How is a Step generator used in UFT?
explain abt dyanamic changing object with example?
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya
what is meant by source control?
I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.
What is debugging? How you debug your script?
suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?
what is run-time data?
What are parameterizing tests?
How to get the particular property value?
Is it possible to merge two object repository files in qtp?
Analyzing the checpoint results?
