Answer Posted / gourav

select * from emp(table name)
where rownum = 1 and 30



this query will display the first and last record


for eg rownum start from 1 and rownum last record is 30..by
execute this query u wil get frst and last reord

Can a foreign key be null?

1144

---

What is dense_rank in sql?

1049

---

What is sql*loader and what is it used for?

1225

---

What is duration in sql profiler trace?

1140

---

How to combine two stored procedures in sql?

1328

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1010

---

How to call shell script from pl sql procedure?

1360

---

Which command is used to delete a trigger?

1408

---

What are different functions in sql?

1000

---

what is a database lock ? : Sql dba

1227

---

Explain architecture of sql server notification services?

1117

---

what is acid property in database? : Sql dba

1071

---

What is clustered index in sql?

1101

---

What is column?

1037

---

What are the various restrictions imposed on view in terms of dml?

1020

---