Interested to Buy Any Domain ? << Click Here >> for more details...
query to retrive the employees whose sal is greater than avg
sal
- 10 Answers
- 15522 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / shiva
select e.* from emp e where e.sal>(select avg(sal) from emp);
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is rollback?
What is the order of sql select?
Can we have two clustered index on a table?
What is pls integer?
Explain some predefined exceptions.
How do you select unique values in sql?
What are different joins used in sql?
Write a sql query to find the names of employees that begin with ‘a’?
How to order siblings in oracle hierarchy queries?
What are sql*plus environment variables?
How to run pl/sql statements in sql*plus?
How do you drop a trigger?
What is data types in sql?
What is the difference between nested table and varray?
What is the difference between local and global temporary table?
