Answer Posted / ehtesham malik
select * from emp
where rowid = (select min(rowid) from emp
where rowid not in (select min(rowid)
from emp)
)
Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
Show the cursor attributes of pl/sql.
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is an implicit commit?
What is date functions?
What is pl sql script?
How to download oracle sql developer?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What do you understand by case manipulation functions?
what is a database? : Sql dba
What is sql trigger example?
what is isam? : Sql dba
What are the types of records?
Define a temp table?
Are sql connections encrypted?
What is the difference between an inner join and an outer join?