5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.
Answer Posted / aswini
select * from <table_name> where salary in(select max
(salary) from <table_name>);
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How can you merge two tables in oracle?
How to count duplicated values in a column in oracle?
What is the difference between postgresql and oracle?
What are the attributes that are found in a cursor?
How do we get field details of a table?
What would you do with an in-doubt distributed transaction?
How to use like conditions in oracle?
does the query needs a hint to access a materialized view?
How to get a create statement for an existing table?
What is catalog in Oracle?
Explain the use of inctype option in exp command.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the difference between translate and replace in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain the use of grant option in exp command.