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
- 31195 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / avinash
select ename from emp where sal in(select max(sal) from
emp) and deptno in(10,20)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is #table in sql?
What are the subsets of sql?
How do we use distinct statement? What is its use?
how to convert character strings to dates? : Sql dba
What are all the common sql functions?
How can we make an if statement within a select statement?
What is the most important ddl statements in sql are?
How to fix oracle error ora-00942: table or view does not exist
What is the cause of mutating table error and how can we solve it?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Is postgresql a nosql database?
How to return an array from java to pl/sql?
How do I view output in sql developer?
What is not in sql?
How do I make my sql query run faster?
