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
- 10306 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
How to restart a DB2 program?
What does db2 mean?
What is the maximum size of a char data type in db2?
Explain what are the various isolation levels possible?
How can you do the explain of a dynamic sql statement?
List out the buffer pools in db2
What is dbrm library?
How do you stop a db2 database in linux?
What do you mean by rollback?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is a bind card?
What is database alias db2?
How do we specify index to include or not during bind process.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
