Oracle Select Query with row limit

Question

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

select TOPIC,SEQ,INFO FROM HELP where rownum < 150 ; this should work..Limit doesnot work with select in oracle — XING
– XING, Commented Sep 8, 2016 at 8:19

Sunil B N · Accepted Answer · 2016-09-08 08:19:28Z

1

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

answered Sep 8, 2016 at 8:19

Sunil B N

4,2251 gold badge33 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

apomene · Accepted Answer · 2016-09-08 08:18:29Z

0

using ROWNUM:

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

edited Sep 8, 2016 at 8:18

answered Sep 8, 2016 at 8:16

apomene

14.4k10 gold badges51 silver badges76 bronze badges

3 Comments

user2582322 Over a year ago

getSampleData Mysql select TOPIC,SEQ,INFO FROM HELP LIMIT 10; Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Deendayal Garg Over a year ago

do not give semicolon and try

user2582322 Over a year ago

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

Abhijeet · Accepted Answer · 2016-09-08 08:19:57Z

0

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;

edited Sep 8, 2016 at 8:19

answered Sep 8, 2016 at 8:19

Abhijeet

4,3491 gold badge26 silver badges42 bronze badges

2 Comments

XING Over a year ago

This is for SQL server.

user2582322 Over a year ago

select TOPIC,SEQ,INFO FROM HELP WHERE ROWNUM <=150 Works fine. THx a lot

Collectives™ on Stack Overflow

Oracle Select Query with row limit

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related