SQLite error running sql file

Question

I am getting a syntax error (near as) on line 22 which is

 CREATE VIEW myDat 
 AS
     SELECT count(*) AS count
     FROM disco l
     GROUP BY l.no;

22   SELECT * as no
     FROM myDat
     WHERE count > (SELECT avg(count) FROM myDat);

I can't seem to figure out what I am doing wrong. I am assuming its the nested SELECT statement in the last line? I looked at the SQLite documentation and it seems be correct. But any other reason for errors?

You can not alias *. * indicates all columns.

Harsh
– Harsh

2015-11-24 00:00:08 +00:00
Commented Nov 24, 2015 at 0:00 — Harsh
– Harsh, Commented Nov 24, 2015 at 0:00
What is the error message, and what isall the code?

philipxy
– philipxy

2015-11-24 00:35:17 +00:00
Commented Nov 24, 2015 at 0:35 — philipxy
– philipxy, Commented Nov 24, 2015 at 0:35

Harsh · Accepted Answer · 2015-11-24 00:02:21Z

2

Change query to remove alias or set alias as below:

SELECT count as no
FROM myDat
WHERE count > (SELECT avg(count) FROM myDat);

answered Nov 24, 2015 at 0:02

Harsh

1,3178 silver badges14 bronze badges

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

Comments

Thinkeye · Accepted Answer · 2015-11-24 21:16:39Z

0

You can't alias asterisk. You must remove alias, or replace asterisk by the column name count.

answered Nov 24, 2015 at 21:16

Thinkeye

96813 silver badges22 bronze badges

Collectives™ on Stack Overflow

SQLite error running sql file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related