Differences between MS SQL Server 2000 and Oracle 10g

[hunter1981]

Please prompt me what exist the differences between syntax in offer "SELECT" in MS SQL Server 2000 and Oracle 10g. What exist the analogues of the offer "TOP" in Oracle 10g?
Excuse me for my english....

[exterminator]

Look at the following links for select query:

1. MS SQL Server - T-SQL - SELECT (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp)
2. Oracle reference - SELECT (http://www.psoug.org/reference/select.html)

I hope this is what you were looking for!!?? And for the analogy of TOP in SQL server T-SQL you use SET ROWCOUNT like this:
set rowcount 100
select * from mytable
set rowcount 0
Hope this helps. Regards.

[hunter1981]

Thanks a lot!!!! You really helped me!

[exterminator]

Thanks a lot!!!! You really helped me!You are welcome. :)