Interested to Buy Any Domain ? << Click Here >> for more details...
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
Artifacts in design phase of SDLC ?
How we test the bulk of contents in web page using manual testing? Is any open source tool available for that ? Thanks in advance..
Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.
What are the different servers and difference between them?
What knowledge I must have as a 3 yrs. manual tester??
what is the general pattern of explanation of projects in interview, can u ans me plz.......... ex: online banking application
What do you mean by Unit Testing, Integration Testing, System Testing, and User Acceptance Testing and when do you do them?
What are the different types of software testing?
Tell some examples of bug severity and bug priority?
What is sanity?
What are the phases involved in software testing life cycle?
What is defect validity ratio?
Work flow in testing in your company?
Please Tell me About Fish-Bone Model. Thanks in Adv.
what is mean by impact analysis ,how we used to select regression TC using this?
