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..
Answers were Sorted based on User's Feedback
Answer / hitesh kumar vyas s
Take a example as to find the same student who got first and
second marks in each of sub.
SELECT RollNo,COUNT(Rank) FROM Student GROUP BY RollNo,rank
ORDER BY rank
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / vikas kant
select key,count(key1) from [table_name]
group by key
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / hanamesh havale
select top 10 cast(key as varchar)
+ '(' + cast(count(key) as varchar) + ')'
from TableName
group by key
Hanamesh Havale
Influx Infotech
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / saravanan p
Select cast(idKey as varchar)+'('+cast(count(idKey) as
varchar)+')'
from #tbl1 group by idKey
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / pradip jain
select convert(varchar,key) + '('+ convert(varchar,
count(key))+')' from table_name group by key
Hanamesh, why top 20?
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / neeraj
If the column name is key
select key,count(*) from jojo
group by key
simple
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / devraj
Table Str:- create table T
( COL1 NUMBER(2));
Data:- select * from t;
col1
1
1
1
2
2
3
3
4
4
5
5
5
Query:-
Select col1 || '(' || Count(col1) || ')' From t Group By
col1;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rakesh prasad
In Sql server 2005
select col + '('+ cast (count(col)as varchar(1000))+')'from
tablename group by col
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manju
select key,count(key)as"count of items" from tablename
group by key order by key
Is This Answer Correct ? | 0 Yes | 0 No |
Scalability, Availability, Integration with internet, etc.)?
Define the term DML, DDL and DTL?
What are pages and extents? : SQL Server Architecture
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How to enter date and time literals in ms sql server?
How many triggers you can have on a table?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
How to get the definition of a view out of the sql server?
How many types of Outer Joins?What are they?
What are the types of dml?
What is a function? Give some example?