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 / vikas kant
select key,count(key1) from [table_name]
group by key
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of having an index on the sql server?
What is trigger explain with program?
Explain can SSRS reports Cache results?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the data type of time?
How to get a list all databases on the sql server?
Explain what is analysis service repository?
How many types of functions are there in sql server?
What is PROJECTION Operation?
What is bit data type?
What is microsoft sql server?
What is open database communication (odbc)?
what are user defined datatypes and when you should go for them? : Sql server database administration
Indexes are updated automatically is the full-text index also updated automatically?
What is the most common trace flags used with sql server?