Interested to Buy Any Domain ? << Click Here >> for more details...
An employee table, with the columns id, name, sal and
dob.Query to select emp names of all highest salaries(there
are 4-5 people having the same salary which happens to be
the highest).
- 5 Answers
- 9401 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / naveen kamatam
select ename, salary from emp e
where 4 > (select count(distinct salary)from emp where
Salary > e.salary)
it will fetch top 4 high salary records
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
can u write some high level scenarios on ms outlook express
how can u prepare the test plan?
Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.
Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain
what s test block ratio? please any one answer me..
I have interview on Guide wire testing. If you please share me.
what is agile model and spiral maodel?pls explain with an example?
Hi, I am planing to give ISTQB - Foundation level exam. Can anyone forward the ISTQB materials at laxmi_002@rediffmail.com mail ID.
What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
What are the bussiness scenories?
What is the limit for test steps?It should be 10/20/30etc
what are the tests u did in entire project? when it did in the project? (means at the release build to end of project) plz explain clearly
What is sanity?
What are the disadvantages of manual testing?
what is e-tester?
