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

What is the Difference between 2 tier and 3 tier Applications...Actually what is a tier.. Anybody can body can give accurate answer..Thanks in advance..........

7 Answers   Symphony,

who will performe smoke testing?... by Senthil BE Software test Engineer(polaris..)

3 Answers   Polaris,

I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)

0 Answers  

CAN WE ADD NEW OBJECTS & PROPERTIES INTO SHARED OBJECT REPOSITORY?

2 Answers   RBS, Wells Fargo,

diff stages between open and fixed status in defect bug cycle

11 Answers   Wipro,

What are all the important Key Metrics in Software Testing?

1 Answers  

What is LOI Testing?

1 Answers  

write the test cases on prime number with result?

6 Answers   Allied Group, Zycus Infotech,

what is quality assurance,quality control and configuration management systems?

4 Answers   Wipro,

WHAT IS THE DIFF BW CLIENT SERVER APPLN,WEB APPLN, 1TIER APPLN,2TIER APPN , 3 TIER APPLN, WINDOWS APPLN? WHICH APPLNS ARE SAME? WHICH IS IMP?

3 Answers   Value Labs,

Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?

0 Answers   eMids,

what is checkin & checkout ?

6 Answers