Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ramesh.ch
select max(salary) from emp
where salary< ( select max(salary) from emp)
explanation::
first sub query returns maximum salary of employee
than main query returns maximum salary lessthan the maximum
salary return by subquery
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Whether any commands are used for months calculation? If so, what are they?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Is primary key indexed by default in oracle?
What privilege is needed for a user to create views in oracle?
What is transport network substrate (tns) in oracle?
What is object data modeling?
How do we get field details of a table?
how the indexes are stored in the Oracle Database?
What are operators in oracle?
Which environment variables are absolutely critical in order to run the OUI?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to upsert (update or insert into a table)?
What is an oracle data file?
What is the difference between $oracle_base and $oracle_home?
How to rebuild an index in oracle?
