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
- 9175 Views
- ADP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sujan thota
select name from emp where sal=(select max(sal) from emp)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / varun b n
select * from emp where sal = (select Max(sal) from emp)
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / n. pavankumar
select * from emp where sal in (select max(sal) from emp)
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / n@n!
emp table= emp;
column id =column_id;
name = name;
sal= sal;
dob= dob;
select top 1 name,sal,column_id,dob from emp order by sal
desc
while u run this query only one row was effected which
shows employee taken highest salary along with details like
column id,dob,name,sal.
if u want 5 employees list then replace top 1 by top 5
plz let me know if it was wrong (along with ur
query)...................
| Is This Answer Correct ? | 0 Yes | 5 No |
Explain Localization Testing ?
why nds?
what is deffered status?
How the test plan is a tool and the product?
I attendend written test in NDS bangalore in aug 2009. 20 aptitude and 10 descriptive questions. In aptitude they ask sums from time and work,time and distance,tap,feet and inches(12 inches=1feet),percentage etc...
Suppose,u have written 10 test cases for an application,but ur developer is not satisfied wht u wrote,then how will u justify him that ur test cases are correct?
What is change request,how u use it
Please write 4 high severity & high pririty bugs on ONLINE SHOPPING OF PRODUCT.Write bugs that should be practical and original.Thank u
If we outsource the testing work, then who prepares the Test Plans? The client or the testing people
Do submit teststrategy to customer if yes at what time
0 Answers Kanbay, Miracle Solutions,
Project had been started in Manual testing and Automation of some fixed modules, Then finally decided to Test the total Application in Automation then it is possible to test that application.
Suppose one project is given to u.How do u know whether this project is suitable for manual testing or automation.
Automation Testing 
