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
- 10784 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
is it compulsory commitment control in journal?
What is scrollable cursor in db2?
What are concurrency issues?
What is the use of db2?
Explain about mirror activator disk mirroring?
Are view updateable?
What is rct?
What is sqlca’s maximum length?
What is image copy in db2?
Explain about rct.
What is reorg?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Name the various locking levels available?
How does db2 sample database connect?
Can we delete records from view?
