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

How to trouble shoot if unable to connect SQL Server

1478


Do you know what guidelines should be followed to help minimize deadlocks?

532


What is normalization and what are the advantages of it?

511


Can we use having clause without group by?

544


How to send email from database?

571






what is the difference between a primary key and a unique key? : Sql server database administration

523


Which joins are sql server default?

500


What happens on checkpoint?

608


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

627


How to create a local temporary stored procedure?

495


What is the difference between a clustered index and a non-clustered index?

524


What are the five major components of a dbms?

508


What is difference between index and primary key?

578


Is sql server 2016 free?

526


What is an entity-relationship diagram (erd)?

580