I want the count of a total groups.
I have following query. I want how many groups 开发者_如何转开发this query returned based on web_id. Lets suppose if it grouped under 4 groups. I need count 4.
select * from web_details where redirected = false group by web_id
I hope my question is understood.
I just figured it out how can I do this.
The ideas was so simple but I was not clicking it.
select count(*) from 
(
    select * from web_details 
    where redirected = false group by web_id
) as temp;
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论