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
- 31267 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / sp
select top 2 ename, salary, dept from dbo.employee where
dept in(10,20) order by salary desc
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of a secondary key?
How to move files from one directory to another in pl sql?
Can we create index on primary key?
What is the difference between rollback and rollback to statements?
how to use 'mysql' to run sql statements? : Sql dba
what are date and time functions in mysql? : Sql dba
What is integrity in sql?
How is pl sql different from sql?
Can a commit statement be executed as part of a trigger?
What is dense_rank in sql?
What does where 1 1 mean in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Where is all the data on the internet stored?
What does plv msg allows you to do?
What is rowid in sql?
