By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
I want to test to make sure that a query is working in Toad. I would like to pull the top 10 rows, but select top 10, column, column, etc. doesn't seem to run.
Below is an example of a Top-10 SQL:
select empno, ename, sal
(select empno, ename, sal
order by sal desc)
where rownum <=10;