Q
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;

Dig Deeper on Using Oracle PL-SQL

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close