Oninit cdi / Archive
Talk to an expert →

Select first n rows from the table

Posted in 2000

Topics: Versions, Editions & End-of-Life

DEEPAK RAJ PATEL — — source: Informix-list mailing list archive (1991-1998)

Hi, Can you please give the sql syntax for getting the first 50rows (say) from a table containing 200 rows in a select querry statement in IDS 7.31 enviornment. Thanks Deepak ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1

↪ replying to DEEPAK RAJ PATEL
Savio Pereira — — source: Informix-list mailing list archive (1991-1998)

select first 50 * from table_namehth savio DEEPAK RAJ PATEL wrote: > Hi, > > Can you please give the sql syntax for getting the first 50rows (say) from a > table containing 200 rows in a select querry statement in IDS 7.31 > enviornment. > > Thanks > Deepak > > ____________________________________________________________________ > Get free email and a permanent address at http://www.netaddress.com/?N=1

Glossary