Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
- 13 Answers
- 19472 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / cbigmudre
(select * from table limit 0,1)
union
(select * from table order by Id desc limit 0,1)
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / gourav
select * from employees
where employee_id=100
union
select* from employees
where employee_id=206;
Example
first coulumn_ id(100)
last column _id(206)
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / ravi singh
select * from table_name
where rownum = 1
union
select * from table_name
where rownum > (select (count(1) - 1) from table_name);
I think this should work. try
| Is This Answer Correct ? | 3 Yes | 18 No |
How to set up sql*plus output format in oracle?
how do you know if your mysql server is alive? : Sql dba
what is inline view?
How can you load microsoft excel data into oracle? : aql loader
select top 3 sal from each dept?
17 Answers IBM, TCS,
What is difference between mysql and postgresql?
What does sign mean sql?
How to copy a table in another table with datas?
What are the types of sql commands?
What is audit logout in sql profiler?
What is a scalar value in sql?
Why query optimization is needed?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
