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
- 30155 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / praveen reddy.eddula
select ename from emp where sal in(select max(sal) from emp
where deptno in(10,20))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to get the third highest salary of an employee from employee_table?
What is the trigger in sql?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
describe transaction-safe table types in mysql : sql dba
What is an exception in PL/SQL? What are the two types of exceptions?
What is rownum?
How do I find duplicates in two columns?
Does group by remove duplicates?
Why stored procedure is better than query?
Inline the values in PL/SQL, what does it mean.?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is the difference between sql and mysql?
How sql query is executed?
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 are the disadvantages of mysql? : Sql dba
