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.
Answer Posted / swati
select top 1 ename from emp where deptno in(10,20) order by
sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I run a sql query in pgadmin 4?
what is sql profiler? : Sql dba
Which data type is a composite type?
What is trigger point?
Which data dictionary views have the information on the triggers that are available in the database?
How do I edit a stored procedure?
What does pl sql developer do?
Is ms sql is free?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How to take user input in pl sql?
What are the subsets of sql?
Why do we use %rowtype & %type in plsql?
What is full join in sql?
how to use 'mysql' to run sql statements? : Sql dba
How do I tune a sql query?