Answer Posted / sidhu

For ex: emp table, we want last five transaction in emp

select * from emp
minus
select * from emp where rownum <= (select count(*)-&n from emp);

this will work and give the value 5 it will return last five transacitons.
hope this helpful

Is sql considered coding?

1011

---

how many columns can be used for creating index? : Sql dba

915

---

What are different functions in sql?

912

---

What is normalization in a database?

1126

---

How to check if a column is nullable before setting to nullable?

1079

---

what is meant by urlencode and urldocode? : Sql dba

1114

---

Explain the the update statement in sql?

1002

---

Explain architecture of sql server notification services?

1012

---

What is the syntax and use of the coalesce function?

1118

---

What program will open a mdb file?

934

---

what is timestamp in mysql? : Sql dba

1033

---

Is coalesce faster than isnull?

924

---

How do I run a script in sql developer?

915

---

what is 'mysqlshow'? : Sql dba

986

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

973

---