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