Select a Missing Rows

winchaat · New User Joined: 23 Mar 2005 Posts: 14

I have a requirement to select the rows from table which is not exist,
consider minimum value for eno is 01 & max 10, whithin this i need to select missing eno's.

anyone help pls!!!

ex-

eno dept
01 ABC
02 DEF
04 DEF
06 HJE
07 KLM
09 KLM
10 MSN

O/P Should be like this

eno

03
05
08

BY
RAG

gowtham_1982 · Active User Joined: 02 Dec 2005 Posts: 116

rajesh_1183 · Posted: Mon Jan 02, 2006 11:24 am Post subject: Re: Select a Missing Rows

hi,

if ur eno follows the sequence...then use cursors...and a variable counter...compare the variable counter with each record fetched by the cursor...and write the missing records to a file..increment the variable counter for every read by the cursor..if ur table is not having duplicates..

Rajesh/Seshu