Count all rows for each DISTINCT

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
1
down vote

favorite

How can count all rows of WHERE statement:

SELECT DISTINCT column1 FROM table COUNT WHERE date::text LIKE '%2014%';

My output:

column1
=======
info1
info2
info3

Desired OUTPUT:

column1|number_of_rows
=====================
info1 | 2000
info2 | 1500
info3 | 1000

Can you support me How can improve it?

Thanks in advance.

edited Nov 16 at 18:31

MDCCL

6,61531743

asked Nov 16 at 17:56

Mareyes

174

add a comment |

up vote
1
down vote

favorite

How can count all rows of WHERE statement:

SELECT DISTINCT column1 FROM table COUNT WHERE date::text LIKE '%2014%';

My output:

column1
=======
info1
info2
info3

Desired OUTPUT:

column1|number_of_rows
=====================
info1 | 2000
info2 | 1500
info3 | 1000

Can you support me How can improve it?

Thanks in advance.

edited Nov 16 at 18:31

MDCCL

6,61531743

asked Nov 16 at 17:56

Mareyes

174

add a comment |

up vote
1
down vote

favorite

How can count all rows of WHERE statement:

SELECT DISTINCT column1 FROM table COUNT WHERE date::text LIKE '%2014%';

My output:

column1
=======
info1
info2
info3

Desired OUTPUT:

column1|number_of_rows
=====================
info1 | 2000
info2 | 1500
info3 | 1000

Can you support me How can improve it?

Thanks in advance.

edited Nov 16 at 18:31

MDCCL

6,61531743

asked Nov 16 at 17:56

Mareyes

174

How can count all rows of WHERE statement:

SELECT DISTINCT column1 FROM table COUNT WHERE date::text LIKE '%2014%';

My output:

column1
=======
info1
info2
info3

Desired OUTPUT:

column1|number_of_rows
=====================
info1 | 2000
info2 | 1500
info3 | 1000

Can you support me How can improve it?

Thanks in advance.

postgresql query count distinct

edited Nov 16 at 18:31

MDCCL

6,61531743

asked Nov 16 at 17:56

Mareyes

174

edited Nov 16 at 18:31

MDCCL

6,61531743

asked Nov 16 at 17:56

Mareyes

174

edited Nov 16 at 18:31

MDCCL

6,61531743

edited Nov 16 at 18:31

MDCCL

6,61531743

edited Nov 16 at 18:31

MDCCL

6,61531743

asked Nov 16 at 17:56

Mareyes

174

asked Nov 16 at 17:56

Mareyes

174

asked Nov 16 at 17:56

Mareyes

174

add a comment |

1 Answer
1

active

oldest

votes

up vote
5
down vote

accepted

In this case you can use GROUP BY to get distinct column1 values, and instead of convert the date to text you can use EXTRACT function for this purpose.

select 
 colum1, 
 count(*) as number_of_rows
from 
 your_table
where 
 extract(year from date) = 2014
group by 
 column1;

edited Nov 16 at 19:01

answered Nov 16 at 18:49

McNets

13.5k41753

Thank you! is working.
– Mareyes
Nov 16 at 19:56

I'm glad to help
– McNets
Nov 16 at 20:04

add a comment |

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222754%2fcount-all-rows-for-each-distinct%23new-answer', 'question_page');

);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

up vote
5
down vote

accepted

In this case you can use GROUP BY to get distinct column1 values, and instead of convert the date to text you can use EXTRACT function for this purpose.

select 
 colum1, 
 count(*) as number_of_rows
from 
 your_table
where 
 extract(year from date) = 2014
group by 
 column1;

edited Nov 16 at 19:01

answered Nov 16 at 18:49

McNets

13.5k41753

Thank you! is working.
– Mareyes
Nov 16 at 19:56

I'm glad to help
– McNets
Nov 16 at 20:04

add a comment |

up vote
5
down vote

accepted

In this case you can use GROUP BY to get distinct column1 values, and instead of convert the date to text you can use EXTRACT function for this purpose.

select 
 colum1, 
 count(*) as number_of_rows
from 
 your_table
where 
 extract(year from date) = 2014
group by 
 column1;

edited Nov 16 at 19:01

answered Nov 16 at 18:49

McNets

13.5k41753

Thank you! is working.
– Mareyes
Nov 16 at 19:56

I'm glad to help
– McNets
Nov 16 at 20:04

add a comment |

up vote
5
down vote

accepted

In this case you can use GROUP BY to get distinct column1 values, and instead of convert the date to text you can use EXTRACT function for this purpose.

select 
 colum1, 
 count(*) as number_of_rows
from 
 your_table
where 
 extract(year from date) = 2014
group by 
 column1;

edited Nov 16 at 19:01

answered Nov 16 at 18:49

McNets

13.5k41753

In this case you can use GROUP BY to get distinct column1 values, and instead of convert the date to text you can use EXTRACT function for this purpose.

select 
 colum1, 
 count(*) as number_of_rows
from 
 your_table
where 
 extract(year from date) = 2014
group by 
 column1;

edited Nov 16 at 19:01

answered Nov 16 at 18:49

McNets

13.5k41753

edited Nov 16 at 19:01

answered Nov 16 at 18:49

McNets

13.5k41753

answered Nov 16 at 18:49

McNets

13.5k41753

answered Nov 16 at 18:49

McNets

13.5k41753

Thank you! is working.
– Mareyes
Nov 16 at 19:56

I'm glad to help
– McNets
Nov 16 at 20:04

add a comment |

Thank you! is working.
– Mareyes
Nov 16 at 19:56

I'm glad to help
– McNets
Nov 16 at 20:04

Thank you! is working.
– Mareyes
Nov 16 at 19:56

I'm glad to help
– McNets
Nov 16 at 20:04

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

搜尋此網誌

mjhjmtu