Interested to Buy Any Domain ? << Click Here >> for more details...
quary for
1> fetch last record
2> fetch in reverse order
3> fetch last 5 row
4> fetch second last record (their is no primary key)
i think concept of count can be use for this in 4th
- 5 Answers
- 10573 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudipta
the 4th answer is(ignore the previous one)
db2=> with t1(a,b,c) as (select id,name,row_number()
over(order by id desc) as aa from tab1) select * from t1
where c=2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Define db2.
Which is faster delete or truncate?
What is query_cache_limit?
How to check table size in db2 sap?
How do I add a column in db2?
What is table space in db2?
What is the use of dclgen in db2?
Give the name of some fields form sqlca.
Discuss about db2 bind?
What is plan in cobol db2?
How to check last update on table in db2?
Define sqlca.
How can record locking be achieved in those DB2 versions which do not support it?
What is cursor stability in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
