select top 1 * from table where dept_no in(10,20) order by sal desc

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / swati pise

24 Answers
30228 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / swati pise

select top 1 * from table where dept_no in(10,20) order by
sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What has stored procedures in sql and how we can use it?

1059

What is difference between hql and sql?

1055

What is 19 null in sql?

939

Is sql developer case sensitive?

982

Can a trigger call a stored procedure?

1053

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1061

what are the advantages and disadvantages of views in a database? : Sql dba

1029

Do we need to create index on primary key?

904

How do I view a view in sql?

938

Explain the commit statement.

1142

What are all the common sql functions?

1002

Explain the advantages and disadvantages of stored procedure?

1134

What is bind reference and how can it be created?

1005

what are all the different types of indexes? : Sql dba

1036

What are different types of tables in sql?

981