Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to find out the no. of employees whose age is
less than 25 and max of salary for the employees belonging
to a particular department is less than 20000
- 6 Answers
- 22794 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikneswaran thangarasu
Ignore my previous post. it is wrong.
select dept,count(emp),max(sal) from employee where age <25
group by dept having max(sal) <20000
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the properties of a transaction?
what is table? : Sql dba
What is the difference between Union and Union all. Which is faster.
What is the most important ddl statements in sql are?
Show the cursor attributes of pl/sql.
Is stored procedure faster than query?
What is oracle sql called?
Can we insert delete data in view?
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.
define sql insert statement ? : Sql dba
Which one is better subquery or joins?
how to load data files into tables with 'mysqlimport'? : Sql dba
How is use pl and sql?
Is crud a cuss word?
how can we destroy the cookie? : Sql dba
