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).
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
Which are the different tests for apparel testing?
When the GUI Testing will be held on the V model ?
please send me interview questions asked in google in testing - manual
What is software review?
what types of testing have u done in ur project?and expalin it detail?
What is known as data-driven testing?
What is difference between Manual testing and Pega/BPM testing?
State a generalized process for load test? Or explain how you did it previously.
1.what is the approach while writing test cases in your project. 2.tell some intresting scenareo in your project
what type of quetion may be asked for experienced person in manual tester of 1 year?
What are testing techniques? What is difference between general and specific?
how to write defects in excel sheets when defects occured
what are the types of Bug?
Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also
You must test a trouble report where the problem cannot be reproduced. You tried using various test data files and mutations from the data files the customer sent along with the trouble report. The software does not fail the way it did at the customer's site.