Entry

In a sql query,how do u get the first 50 records,when the where clause selects more, say 200 or 1000, without loops and cursors

Dec 5th, 2001 07:12
sivakumar s p, Jayanta Barua,

SELECT  <Col_List> 
  FROM  <TableName>
 WHERE  <Condition>
   AND  <Condition>
   AND   Rownum < 51