How do I count the number of Values inserted in a table in SQL Server?

Question

I have a table like below:

DirectoryName    FileName
    A               Ab.pdf
    B               bc.mp3
    C               cd.doc
    A               de.pdf
    F               fg.pdf
    A               kl.pdf

The output should be like this:

Directory 
 A - 3
 B - 1
 C - 1
 F - 1

And same with FileName.

Thanks

Mr.Bhanushali · Answer 1 · 2017-04-13T05:40:09.657

1

Simple Solution is :

select distinct DirectoryName, count(FileName) 
from tableName group by DirectoryName

Or you can use partition by over DirectoryName

select distinct DirectoryName, COUNT(FileName) 
over(Partition by DirectoryName) 
Count from tableName

Hope this will work for you.

edited Apr 13 '17 at 05:40

answered Apr 13 '17 at 05:30

Mr.Bhanushali

126
12

I was not knowing your requirement, so given both the solutions, if you want to know the difference between this two read this, http://stackoverflow.com/a/2404587/7614961 – Mr.Bhanushali Apr 14 '17 at 04:44
close the question once you are satisfied with answer. @Sam – Mr.Bhanushali Apr 14 '17 at 05:37

How do I count the number of Values inserted in a table in SQL Server?

1 Answers1