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 mysql query is case sensitive? : Sql dba

1102

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1065

---

How would you convert date into julian date format?

1006

---

How do I get sql certification?

975

---

how to check myisam tables for errors? : Sql dba

1321

---

how can you create an empty table from an existing table? : Sql dba

1154

---

What is auto increment?

999

---

What is not equal in sql?

1124

---

What are three advantages to using sql?

1019

---

What are actual parameters and formal parameters?

1103

---

what are wild cards used in database for pattern matching ? : Sql dba

1144

---

How can we make an if statement within a select statement?

1013

---

How do you go back in sql?

986

---

Is delete faster than truncate?

1002

---

Which is better cte or subquery?

1028

---