Answer Posted / nishi
select level, min('col_name') from my_table where level = '&n' connect by prior
('col_name') <'col_name') group by level;
Example:
Given a table called emp with the following columns:
-- id number
-- name varchar2(20)
-- sal number
--
-- For the second lowest salary:
-- select level, min(sal) from emp
-- where level=2
-- connect by prior sal < sal
-- group by lev
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you tell me how to add new column in existing views?how?How is possible?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Design database draw er diagram for a certain scenario ?
Is rowid unique in oracle?
How do I connect to oracle?
What is the usage of analyze command in oracle?
What are the set operators union, union all, minus & intersect meant to do?
What is redo log?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What happens to the indexes if a table is recovered?
How can Oracle users be audited?
What is control file used for?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How do we create privileges in oracle?
Explain the blob datatype?