Problem solve
Get help with specific problems with your technologies, process and projects.
Test to check query in Toad
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.
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
from
(select empno, ename, sal
from emp
order by sal desc)
where rownum <=10;
