How to retrieve first and last records from a table?

Answer Posted / guest

select *from dual;

Is This Answer Correct ?    0 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

523


Explain the use of analyse option in exp command.

584


What is connection pooling in oracle?

544


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1266


Difference between cartesian join and cross join?

536






What is an anonymous block?

615


what is the difference between data migration and production migration.

1803


What is the purpose of tables, private synonyms and public synonyms in Oracle?

585


What is a system tablespace and when it is created?

556


Explain what are the characteristics of data files?

620


what is insert all statement in sql

5491


What are the differences between char and varchar2 in oracle?

557


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1798


How to import one table back from a dump file?

585


Is there a function to split a string in plsql?

564