oracle sql group by column which count them

Question

I ran below query to fetch count of data which I can see in output but it does not working as I wish

How can I print count of col6 & col7 in output?

Am I clear?

select col1, col2, 
col3, col4, decode(col5,'S','Success','F','Failed'), col6, col7, count(*)
from mytable 
where col1 in (select FIELD1 from temp)
and col8 = 4
group by col1, col2, col3,col4,col5,col6,col7

Provide sample data and desired results. Counting columns in the group by clause is not very interesting. The value is always 1 (well, unless the value is NULL). — Gordon Linoff
– Gordon Linoff, Commented Jun 30, 2020 at 11:20

Yaron · Accepted Answer · 2020-06-30 08:42:29Z

1

See if this works

select count(col6), count(col7)
from mytable 
where col1 in (select FIELD1 from temp)
and col8 = 4;

edited Jun 30, 2020 at 8:42

Yaron

1,2411 gold badge15 silver badges36 bronze badges

answered Jun 30, 2020 at 8:35

Vivs

4854 silver badges11 bronze badges

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

Comments

Popeye · Accepted Answer · 2020-06-30 08:30:11Z

0

You need to use the proper aggregate function and remove the col6 and col7 from GROUP BY clause following query:

select col1, col2, col3, col4, decode(col5,'S','Success','F','Failed'), 
      count(col6), count(col7), count(*) -- used count for col6 and col7
from mytable 
where col1 in (select FIELD1 from temp)
and col8 = 4
group by col1, col2, col3,col4,col5 -- removed col6 and col7 from here

answered Jun 30, 2020 at 8:30

Popeye

36k4 gold badges12 silver badges31 bronze badges

Collectives™ on Stack Overflow

oracle sql group by column which count them

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