Re: Select first n rows from the table

From: DEEPAK RAJ PATEL <d_patel123@usa.net> > >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. RTFM. http://www.informix.com/answers -- SQL Syntax Guide. SELECT FIRST 50 col1, col2 FROM table WHERE blah, blah, blah...________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com