Answer Posted / venkyhulk1

select *
from (select rownum r, e.* from emp e)
where r in ((select max(rownum) from (select rownum , e.*
from emp e)),(select min(rownum) from (select rownum , e.*
from emp e)))


this querry will get the first and last records of the table
with respect to the way the data is stored in the table

Can we call stored procedure in function?

905

---

What is the file extension for sql database?

939

---

What is pl sql record in oracle?

971

---

What is prepared statement in sql?

997

---

what is innodb? : Sql dba

1034

---

Determine if oracle date is on a weekend?

984

---

What is the use of desc in sql?

916

---

What is pl sql block in dbms?

952

---

How do you bind variables in pl sql?

1036

---

Can a composite key be null?

912

---

What are sql ddl commands?

1020

---

What is meant by truncate in sql?

1008

---

What version is sql?

966

---

discuss about myisam key cache. : Sql dba

976

---

How many types of relationship are there?

976

---