Ggtcf

Why doesn't a const reference extend the life of a temporary object passed via a function?

How can I add custom success page

Tri-X compared with HP5 plus, grain

How to create a consistant feel for character names in a fantasy setting?

What is the offset in a seaplane's hull?

Why is an old chain unsafe?

How to make payment on the internet without leaving a money trail?

I am not able to install anything in ubuntu

Send two commands to a new terminal?

Copycat chess is back

Why do UK politicians seemingly ignore opinion polls on Brexit?

Can not use big prime number for pair of key of RSA Algorithm

Calculate Levenshtein distance between two strings in Python

Why is the design of haulage companies so “special”?

Weird behaviour when using querySelector

Why is "Reports" in the sentence below without the article "The"?

Are white and non-white police officers equally likely to kill black suspects?

LM317 - Calculate dissipation due to voltage drop

Email Account under attack (really) - anything I can do?

Denied boarding due to overcrowding, Sparpreis ticket. What are my rights?

how to create a data type and make it available in all Databases?

Is it true that "The augmented fourth (A4) and the diminished fifth (d5) are the only aug and dim intervals that appear in diatonic scales"

Extreme, but not acceptable situation and I can't start the work tomorrow morning

Is Social Media Science Fiction?

postgres query for count of value dict

How do you find the row count for all your tables in Postgrespsql: FATAL: Ident authentication failed for user “postgres”postgres: upgrade a user to be a superuser?Postgres could not connect to serverGetting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with railsCounts of unique values in Postgres GROUP BYSQL advanced query counting the max value of a groupPostgreSQL / Oracle => query to group and count hierarchical valuesCount unique nested key/values in a json in postgres?Querying a JSON array of objects in Postgres

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have below data

I want top five value count of inner object by outer object key.

ans should be:- 49:322, 47:290 ,50:46,55:40,52:0

postgresql

share|improve this question

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

asked Mar 9 at 4:13

rupalirupali

11

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Edit your question and post the sample data set in plain text format. Also, kindly mention how did you get 46 for 50 and not 50 and where did 55 come from in your data?
  
  – Kaushik Nayak
  Mar 9 at 6:19
  

  
  
  
  

add a comment | 

0

I have below data

I want top five value count of inner object by outer object key.

ans should be:- 49:322, 47:290 ,50:46,55:40,52:0

postgresql

share|improve this question

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

asked Mar 9 at 4:13

rupalirupali

11

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Edit your question and post the sample data set in plain text format. Also, kindly mention how did you get 46 for 50 and not 50 and where did 55 come from in your data?
  
  – Kaushik Nayak
  Mar 9 at 6:19
  

  
  
  
  

add a comment | 

I have below data

I want top five value count of inner object by outer object key.

ans should be:- 49:322, 47:290 ,50:46,55:40,52:0

postgresql

share|improve this question

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

asked Mar 9 at 4:13

rupalirupali

11

share|improve this question

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

asked Mar 9 at 4:13

rupalirupali

11

share|improve this question

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

asked Mar 9 at 4:13

rupalirupali

11

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

edited Mar 9 at 7:12

a_horse_with_no_name

307k46468567

asked Mar 9 at 4:13

rupalirupali

11

asked Mar 9 at 4:13

rupalirupali

11