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
What is the difference between baseline and traceability matrix?
Can you explain usability testing?
Is anybody have the telecom systems test cases from start to end?
through which phases a software ttester need to pass like as a junnior test engineer,team lead,project lead,etc.? which is the final stage of your promotion and how will u achieve?
What is the difference between stlc and sdlc?
Iam new to testing field and i put lot of experiences so i want to get prepared for the interview in all the ways both in manual and Automation can any one help me how to answer there questions in real time. also can anyone send the top questions and answers to me plz its urget u can mail me at vaisu72@yahoo.com
Hello everybody, How many people do you think one sprint team can have in average?
Can anybody help i put the pharma and bank project in my resume, but i dont know what to tell about them, any body tell the where can i get the information about them,what i need to tell about these applications,please help me
do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com
can u write some high level scenarios on ms outlook express
what is the use of l10n testing?
Can you explain requirement traceability and its importance?
How can data caching have a negative effect on load testing results?
How to integrate Bugzilla with QTP?
What is a bug triage?