Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve first and last records from a table?
- 7 Answers
- 12260 Views
- DELL, QSmart, I also Faced
- E-Mail Answers
Answer Posted / abc
SELECT * from empl WHERE ROWID IN (
SELECT MAX(ROWID) FROM empl
UNION
SELECT MIN(ROWID) FROM empl
);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by a database object? Can you list a few of them?
What is a dead lock in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to retrieve the count of updated rows?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is oracle instant client?
What is backup in Oracle?
How do I learn what codesets are available in oracle?
Can the query output be sorted by multiple columns in oracle?
How to use group functions in the select clause using oracle?
Explain oracle’s server parameter file.
How to assign values to data fields in record variables?
How does one get the view definition of fixed views/tables?
How different is ms access and oracle?
How to install oracle database 10g xe?
