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
- 22261 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikneswaran thangarasu
select dept,count(emp),max(sal) from employee where age <25
and sal <20000 group by dept
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a primary key and a clustered index?
Can %notfound return null after a fetch?
How many types of keys are there in sql?
How many developers work on postgresql?
Write a sql query to find the names of employees that begin with ‘a’?
What is the maximum number of columns in sql table?
What is the limitation on the block size of pl/sql?
What is the difference between a primary key and a unique key?
What are all types of user defined functions?
Can you skip header records while loading? : aql loader
What is an inner join sql?
What is union, minus and interact commands?
How many types of triggers are there in pl sql?
What is a sql instance vs database?
What are %type and %rowtype for?
