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
- 29884 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 information is needed to connect sql*plus an oracle server?
How do you use collections in procedure to return the resultset?
What does pl sql developer do?
Can a table contain multiple foreign key’s?
How can you view the errors encountered in a trigger?
How do I view tables in sql developer?
What is an implicit commit?
What are the different parts of a package?
What is acid property in a database?
How do you use join?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is case function?
describe transaction-safe table types in mysql : sql dba
How do I edit a stored procedure?
