SQL : Sum of the Count of number of rows in a column

Question

I have the following column , i want to get the total count of unique rows next to each row . How would i do that ?

The Column i have   |  Col i want
52806                        9
52806                        9
52806                        9
53317                        9
54620                        9
54722                        9
54830                        9
54917                        9
54923                        9
54942                        9
54947                        9
54947                        9

i searched for the appropriate answer online i could not find it anywhere !! I don't want to use group by clause because its a big query

You mean like select count(distinct column) from mytable?

ZLK
– ZLK

2017-04-25 21:13:29 +00:00
Commented Apr 25, 2017 at 21:13 — ZLK
– ZLK, Commented Apr 25, 2017 at 21:13
if i use count it gives me 1 in every row

sandesh b n
– sandesh b n

2017-04-25 21:15:17 +00:00
Commented Apr 25, 2017 at 21:15 — sandesh b n
– sandesh b n, Commented Apr 25, 2017 at 21:15

Lamak · Accepted Answer · 2017-04-25 21:19:06Z

1

Sounds like a CROSS JOIN:

-- CROSS JOIN
SELECT A.[The Column],
       B.[Col you want]
FROM dbo.YourTable A
CROSS JOIN (SELECT COUNT(DISTINCT [The Column]) [Col you want]
            FROM dbo.YourTable) B
;

edited Apr 25, 2017 at 21:19

answered Apr 25, 2017 at 21:15

Lamak

70.8k12 gold badges118 silver badges119 bronze badges

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

4 Comments

Lamak Over a year ago

@sandeshbn weird. Well, the CROSS JOIN should work

sandesh b n Over a year ago

the column i want is not in the database table , its the count that i want to add

Lamak Over a year ago

@sandeshbn I don't get it. This answer gives you the otuput you wanted. You'll need to clarify your question

sandesh b n Over a year ago

@Lamak : sorry my bad . Got it Thanks a lot

Shridhar · Accepted Answer · 2017-04-25 21:28:42Z

0

I believe this should work

select T.TableColumn, COUNT(T.TableColumn) AS ComputedCol FROM GivenTable T GROUP BY T.TableColumn

answered Apr 25, 2017 at 21:28

Shridhar

697 bronze badges

Collectives™ on Stack Overflow

SQL : Sum of the Count of number of rows in a column

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related