Oracle Select Query with row limit

0
votes

This is my Oracle query

select TOPIC,SEQ,INFO FROM HELP TOP 150;

and below is the exception

java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

3
javaoraclesqlexception
oracle use other methods to fullfill top - passion
select TOPIC,SEQ,INFO FROM HELP where rownum < 150 ; this should work..Limit doesnot work with select in oracle - XING

3 Answers

1
votes

Oracle: 

select TOPIC,SEQ,INFO FROM HELP WHERE ROWNUM <= 150

MySQL:

select TOPIC,SEQ,INFO FROM HELP LIMIT 150

SQL Server / MS Access Syntax

select TOP 150 TOPIC,SEQ,INFO FROM HELP
0
votes

using ROWNUM:

 select TOPIC,SEQ,INFO FROM HELP WHERE ROWNUM <=150
0
votes

If you want to use TOP correct query would be : For SQL Server / MS Access

select TOP 150 TOPIC,SEQ,INFO FROM HELP;

Other options : For Oracle and MySql

SELECT TOPIC,SEQ,INFO FROM HELP WHERE ROWNUM <=150;