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
- 30554 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / sumesh s.g
select Name from TBL_Employee
where Salary in(
select max(Salary) from dbo.TBL_Employee
group by DepID
having DepID in(10,20))
--Happy Codding--
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How to run pl sql program in mysql?
What is the difference between view and stored procedure?
What is a database trigger?
What are the advantages of normalization?
Which command is used to delete a trigger?
what are the advantages of mysql in comparison to oracle? : Sql dba
What are all the different types of indexes?
Define overloaded procedure?
How to look at the current sql*plus system settings?
what is sp_pkeys? : Transact sql
Define tables and fields in a database
What does subquery mean in sql?
How do I truncate a sql log file?
What is pl sql block in dbms?
