Hi,
In oracle there is Rownumber,but we can't find it in Ms-SQL,
How can do it too in Ms-SQL?
Regards,
Printable View
Hi,
In oracle there is Rownumber,but we can't find it in Ms-SQL,
How can do it too in Ms-SQL?
Regards,
first, find an MS-sql bulletin board web site.
We got Oracle gurus here. Unless there is some crazy ms-sqlWANNABE running around somewhere ...
sorry that i do not know the answer.
I assume you tried to select rownum.
Use
Select TOP 10 from....