SQl Statement for first 1000 records

[prasadkvv]

Hi,
I have one account table it has more than 10,00,000 records.
But i have to show the first 1000 recods.
What is equlalent query in oracle?
In SQL Server: select TOP 1000 * from Account order by Account_id;

If i used the RowNUm in Oracle but order caluse is ging offf
Pl help for this query

Thanks & regards
Prasad kVV

[abhaysk]

Select 
  * 
From 
  (
   Select 
     * 
   From 
     My_Table 
   Order By 
     My_Col
  ) 
Where 
  Rownum < 1001
;

Abhay.

[prasadkvv]

Thanks Abhay it is working.
Any Other solution it would work for both Oracle and sql server databses?