SQl Statement for first 1000 records

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

Code:

---


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

---

Abhay.

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