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
- 31261 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
What is raid? How does it help storage of databases?
Write a sql query to get the third highest salary of an employee from employee_table?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is an invalid partition table?
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.
what are enums used for in mysql? : Sql dba
Why self join is used in sql?
What is the difference between row level and statement level trigger?
Does oracle use sql?
what is meant by urlencode and urldocode? : Sql dba
Is hadoop a nosql?
How run sql*plus commands that are stored in a local file?
Are subqueries better than joins?
Is sql a case sensitive language?
What is sql injection vulnerability?
