Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 24 Answers
- 29515 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
List the ways to get the count of records in a table?
Why do we need sharding?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How can a pl sql block be executed?
What is graph sql?
How do you optimize a stored procedure in sql?
Why do we need view in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Does view contain data?
Is natural join same as inner join?
What is on delete set null?
What do you mean by stored procedures?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is a Mapplet?
