How to retrieve first and last records from a table?
Answer Posted / avnish srivastava-test engg fc
select* from employees where rowid=(select min(rowid) from
employees)
union
select* from employees where rowid=(select max(rowid) from
employees)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is ASM (Automatic Storage Management) in Oracle?
What would you do with an in-doubt distributed transaction?
State the difference between a primary key and foreign key?
Explain the use of owner option in exp command.
Why do you create or replace procedures rather that drop and recreate.
What is oracle sid?
What is a tns service name?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Explain the difference between replace() and translate() functions in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to experiment a data lock in oracle?
How to get execution statistics reports on query statements?
IS it possible to built the oracle database without setting the kernal parameters?
What is set verify off in oracle?
Can we create database in oracle using command line ?