if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..

1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..

Answer Posted / guest

3

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between clustered index and primary key?

508


how to trace the traffic hitting a sql server? : Sql server database administration

1144


How to concatenate two strings in SQL Server.

600


Can binary strings be used in arithmetical operations?

526


What is data source view or dsv? : sql server analysis services, ssas

559






What are the differences between having and where clause.

559


How to enter comments in transact-sql statements?

557


Can I run multiple instances of sql server 2000 at the same time on one computer?

610


Does the order of columns in update statements matter?

482


What do you know about system database? : SQL Server Architecture

499


What are the differences between decimal and float in ms sql server?

569


Can truncate be rolled back?

547


What is an expression in ms sql server?

573


How can we call UDF(User Define Function) using C# code in ASP.net ?

5946


How to edit table in sql server 2017?

514