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
- 29843 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / lipika
Select Ename From emp where sal in (Select Max(Sal) From
emp where deptno in (10,20) group by deptno);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Write a sql query to convert all character to uppercase after hypen.
What is sap sql anywhere?
How to run sql statements through the web interface?
What are the most important characteristics of pl/sql?
how many groups of data types? : Sql dba
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How do you get column names only for a table (sql server)?
What are crud methods?
What if we write return in procedure?
What is dml and ddl?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Is trigger a stored procedure?
what is bcp? When is it used?
What is composite primary key in sql?
