multiple count in a single query in oracle

Question

I'm trying to get output from :

select count(r.id) and count(r.key) from rules r where lower(r.name) in ('xss attack','dos attack') ;

but getting error like

ORA-00923: FROM keyword not found where expected

What happens if you try select count(r.id), count(r.key) from rules r where lower(r.name) in ('xss attack','dos attack') ; — ProgrammersBlock
– ProgrammersBlock, Commented Jun 2, 2017 at 2:35
please check my answer which i replied for above question and what I'm expecting @ProgrammersBlock — mayur
– mayur, Commented Jun 2, 2017 at 2:58
the and in your select list is causing your original problem. Look at Renato's answer below for correct syntax. — unleashed
– unleashed, Commented Jun 2, 2017 at 14:58

Renato Afonso · Accepted Answer · 2017-06-02 10:50:49Z

2

Something like this? :

select count(r.id),count(r.key) from rules
where lower(r.name) in ('xss attack','dos attack')

answered Jun 2, 2017 at 10:50

Renato Afonso

6546 silver badges13 bronze badges

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

Comments

mayur · Accepted Answer · 2017-06-02 02:56:54Z

0

I tried below solution :

select (select count(r.id) from rules r where lower(r.name) in ('xss attack','dos attack')) AS name,(select count(r.key) from rules r where lower(r.name) in ('xss attack','dos attack')) AS name from rules;

Please correct me if any improvement is required for above query.

Output I'm getting is like

NAME   NAME

 2      2
 2      2

while i expect my output should like as

NAME        NAME
 2            2

edited Jun 2, 2017 at 2:56

answered Jun 2, 2017 at 2:06

mayur

112 silver badges4 bronze badges

Collectives™ on Stack Overflow

multiple count in a single query in oracle

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