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
- 10484 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarath
1) select id,name from tab1 order by id desc fetch first
row only
2) select id,name from tab1 order by id desc
3) select id,name from tab1 order by id desc fetch first 5
rows only
4) select id,count(*),name from tab1 order by id where count
(*) = (select count(*) from tab1)-1
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / pavan
please try this one and let me know....
select * from emp where :ws-rec-cnt = (select Count(*)
into :ws-rec-cnt from emp);
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / pavan
the above one is for fetching last record and i think u can
decraese (use < symbol) the count and use it for fetching
nth record in a table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / sudipta
u may try this
assuming table 'tab1' has 2 fields id & name
1) select id,name from tab1 order by id desc fetch first
row only
2) select id,name from tab1 order by id desc
3) select id,name from tab1 order by id desc fetch first 5
rows only
4) select id,count(*),name from tab1 order by id where count
(*)<(select count(*) from tab1)
u try these & if any problem u may write
| Is This Answer Correct ? | 0 Yes | 2 No |
How do you Load a table ?? and what is Load replace ?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
How to test SQL -911 error while developing COB-DB2 program
What is the use of db2?
What is a db2 cursor?
Define buffer pool.
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
Is db2 a database?
What is difference between isnull and coalesce?
wht are the restrictions for union ?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
COBOL 
