Answer Posted / a sameer
By using alias name too we can generate the query
A and B are two alias name for the employee table name
Query:-
select A.* from employee A where N=(selet count(Distinct
B.sal) from employees B where B.Sal > A.sal);
If any one want 2 or any other salary jut replace "the no."
required in place of N, to get the answer.
Hope might understand
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Changes and enhancements to system?
How could you present test strategy for the product testing?
Is there any procedure of web-site development in manual testing. If yes what are factors we should test?
What are the two main categories of software testing?
How to overcome pesticide paradox?
What type of questions will be asking for 2 years experience candidate in manual testing?
What type bugs you will find in integration testing with example?
what types of testing you performed in transfer funds module....
How do test documents in a project span across the software development lifecycle?
How could we start writing testcases without having the FRS,BRS Docs? My Project has some docs that are related to explain the operations which will be done in the application. It is deployed in UAT server and is a maintainance project. Tell me some technipues or best way to provide the quality to application?
What are the advantages of waterfall model?
Write all combinations of test cases for calculater on + symbel
what should be tested when credit card is used as payment option in ecommerce project?can anyone tell me in detail what to test n how to test when credit card is involved in web application?
I have 2 years of exp. in testing and looking for a change if any body knows, about any vacancy in testing then plz contact me on deepti_ac@yahoo.co.in
write test cases on wall