Answer Posted / guest
ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What happens if you lost a data file?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain oracle’s system global area (sga).
Explain the use of log option in exp command.
Explain overloading. Can functions be overloaded?
How can we find out the duplicate values in an oracle table?
What is analyze command used for?
What is key preserved table?
query optmization techniques and quwry analyser+projects+ppts
what is port in oracle? how is it related to database application.
List out the types of joins.
What is a cursor variable?
What are temporal data types in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to count duplicated values in a column in oracle?