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
- 30590 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
Why is nosql good?
Why is the cursor important?
How to make a copy values from one column to another in sql?
How many triggers can be applied on a table?
How do I remove duplicates in two columns?
Why commit is not used in triggers?
What is difference between rank () row_number () and dense_rank () in sql?
What is cross join sql?
What are views in sql?
what is a cursor? : Sql dba
What is sqlite used for?
how to delete an existing column in a table? : Sql dba
What is blind sql injection?
Why does sql need a server?
Can we create table inside stored procedure?
