How to retrieve first and last records from a table?
Answer Posted / girija.112
select *
from employees
where rowid = (select max(rowid)
from employees)
or rowid =(select min(rowid)
from employees)
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
Explain an index?
What is an Oracle Instance?
Can a formula column be obtained through a select statement ?
How to create a table in a specific tablespace?
How to display employee records who gets more salary than the average salary in the department?
Differentiate between function and procedure in oracle.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to define a data source name (dsn) in odbc manager?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Hi Can any one tell me what are the API's used in requisition import.
What is difference between sid and service name in oracle?
What would you do with an in-doubt distributed transaction?
How to define a variable to match a table column data type?
Explain self joins in oracle?