Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
- 7 Answers
- 12913 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sameer
Select * from emplyees
Where sal>(select avg ( sal) from emplyees )
No need to write complex queries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
Explain sessions and how many types of sessions are there?
How many ways are there to do 'remove duplicate records in informatica'?
What is the function of union transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Write the program through which the records can be updated?
How does the aggregator transformation handle null values?
What are session parameters ? How do you set them?
What does command task mean?
r u done any partitions in ur project?
What is Session and Batches?
How to create the source and target database connections in server manager?
What is enterprise data warehousing?
Where is metadata stored?
