Table Str:- create table T ( COL1 NUMBER(2)); Data:- select * from t;

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..

Question Posted / devraj

17 Answers
19677 Views
3i Infotech, Rolta, TCS, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to recreate an existing index in ms sql server?

1116

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

1044

How to use subqueries with the exists operators in ms sql server?

1178

What is query processing?

989

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1104

How to rebuild master databse?

1127

Explain trigger classes i.e. Instead of and after trigger?

918

What are the five characteristics of good data?

972

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1320

In what three ways is the return statement used in a stored procedure?

1062

How to download microsoft sql server 2005 express edition?

1093

Which rendering formats are affected by the pagesize properties?

151

Do you know what are different types of replication in sql server?

1154

How dts is used to extract, transform and consolidate data?

1115

Explain DBCC?

1014