Answer / sujan thota

select name from emp where sal=(select max(sal) from emp)

Answer / varun b n

select * from emp where sal = (select Max(sal) from emp)

Answer / n. pavankumar

select * from emp where sal in (select max(sal) from emp)

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

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)...................

HOw to give special characters to password

3 Answers  

How would you define a "bug?"

9 Answers  

What is Black Phase in SDLC?

2 Answers  

plz anyone can explain me what is PB/MF based application?

1 Answers  

If you're given a program that will average student grades, what kinds of inputs would you use?

0 Answers  

what is defect?

6 Answers  

what is mean by impact analysis ,how we used to select regression TC using this?

0 Answers  

Test case's for a window having 4 button's addition, subdtraction, multiplication,division of two numbers having two no range(0,10000) and result box having range between (100,100000).

1 Answers   ABC,

What is the difference between a bug, a defect and an error?

0 Answers  

What is Soak Testing ?

11 Answers   AZTEC,

can anybody pls tell me that what type of interaction takes place or what type of discussions or questions take place between a tester and client regarding the project.

2 Answers  

What is Configuration management? Tools used?

1 Answers