Why get so complicated. The numbers must be unique in the database. Just get it in a dataset. Generate random number between 0 and the number of rows in dataset, and select that row.
On Sep 17, 8:35 pm, Naval sharma <[email protected]> wrote: > hi > thanks alot... > now i have my ans. verry welll... > really thank u verry much!!!!! > > > > On Fri, Sep 17, 2010 at 11:52 AM, shini gupta <[email protected]> wrote: > > Hi Nawal, > > > I think it wud help u: > > http://weblogs.sqlteam.com/jeffs/archive/2004/11/22/2927.aspx > > > On Fri, Sep 17, 2010 at 7:23 AM, Nawal <[email protected]> wrote: > > >> hi !!! all > >> plz give me ans ..... > >> it is related to sql querry. > >> Question.--> select 10 number randomly in 100 no.'s database ???? > >> plz give me ans if u know..... > >> thanks in advance...
