Hi Everyone,
How to get fist and last record from a table in oracle?
Thanks in advance
Answer Posted / 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 |
Post New Answer View All Answers
Is sql better than excel?
How do you explain an index number?
What does count (*) do in sql?
What are character functions?
Why is pl sql needed?
what are the type of locks ? : Sql dba
What is sql server and ase?
what are the differences between require and include, include_once and require_once? : Sql dba
What does subquery mean in sql?
What are the different dcl commands in sql?
what is sql server agent? : Sql dba
How many types of primary keys are there?
How do you remove duplicates without using distinct in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
what are all the common sql function? : Sql dba