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
- 30493 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / sanjeev
SELECT ENAME FROM TABLE NAME WHERE SAL>(SELECT MAX(SAL)
FROM TABLE NAME GROUP BY DEPTNO
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why is theta join required?
What are the set operators in sql?
Does group by remove duplicates?
How does join work in sql?
Is coalesce faster than isnull?
What are the different types of database management systems?
What is varchar data type in sql?
Explain the savepoint statement.
What is the difference between truncate and drop statements?
What is sql query limit?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What does inner join mean?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
what is the difference between undefined value and null value? : Sql dba
how many ways to get the current time? : Sql dba
