sql - GROUP BY syntax is causing "missing expression" error -


please explain why following query:

select      in.status                    "no_installments" ,           count(in.id)             "installment"        instalsched.instalment in group       in.status; 

returns

ora-00936: missing expression 00936. 00000 - "missing expression" *cause:
*action: error @ line: 1 column: 12

in key word in sql. used part of clause, such where person_id in (1,2,3,4). remedy, change alias.

select    in1.status "no_installments",               count(in1.id)             "installment" instalsched.instalment in1 group in1.status; 

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -