aggregate function like for characters in postgresql

Question

In case of integers, there are aggregate functions such max, min to find the high and low values in a table.

How to do the same for character type? I mean, If a column as a value repeated more than once, and I want to display that value. How to query that?

for example, I have a table programmer and columns such as programmer, lang1, lang2which has many values in those like programmer column has abu, babu, catherine, david and lang1 column has basic, c, basic, sql and lang2 has pascal, pascal, c, cobol.

My objective is to display the maximum repeated value in lang2 column.

Okay. I have a table called program and columns such as programmer, lang1, lang2 and many values entered in those columns. 'lang1' has pascal,pascal,pascal,cobol like values, and I wanna get the result like which language was opted by most of the programmer — zeewagon
– zeewagon, Commented Dec 30, 2015 at 7:53
question is not clear, do you want find rows duplicate column values? — Saketh
– Saketh, Commented Dec 30, 2015 at 8:02
i want to extract the maximum repeated value alone. In the above example, it was pascal. — zeewagon
– zeewagon, Commented Dec 30, 2015 at 8:07
max() and min() will work for character data as well. Edit your question and add some sample data (formatted text please) and the expected output based on that data. — user330315
– user330315, Commented Dec 30, 2015 at 9:00

Vivek S. · Accepted Answer · 2015-12-30 11:01:55Z

1

SELECT lang, COUNT(lang) 
FROM pgm
GROUP BY lang
ORDER BY 2 DESC LIMIT 1

This select query yields maximum repeated language in column lang and its total count

DEMO

edited Dec 30, 2015 at 11:01

answered Dec 30, 2015 at 8:52

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

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

Collectives™ on Stack Overflow

aggregate function like for characters in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related