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
- 8966 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 |
What is verification and validation in software testing? explain with examples?
how to report a bug to the developer?What is the structure of Bug tracking?
Could some one tell me test cases for multi line text boxes like Notes field?
How i can check sql data base
What is testing life Cycle and Explain different phases?
Hi,friends i am going to write ICST certificate exam on augest.So can anybody post some of sample qusetions for ICST certificate exam.Really it will be useful for me
how will you estimate of your website?
What is differnce between bug and error?
what is framework and what is test methodology? (Asked in Zensar Hyderabad today(17-1-12010))
what is 'v'model?
which tool used for gui testing?
what are the testing methodologies?
Automation Testing 
