Question
Shall i use this query to retrieve first 4 records,
Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?
Question Submitted By :: Abuzar
I also faced this Question!!
Rank
Answer Posted By
Re: Shall i use this query to retrieve first 4 records,
Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?
Answer 1 Hi.............
Mr. Cooooool
Re: Shall i use this query to retrieve first 4 records,
Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?
Answer 2 if empno is a primary key then the records in table are
Madhu T
Re: Shall i use this query to retrieve first 4 records,
Select empno, sal from emptbl where empno < 5. like this can
we fetch first 100 records?
Answer 3 I dont think records are stored in the sorted order of primary key in DB2. It happens only in VSAM!
Anju
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
