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

What is the difference between left and right outer join?

1057

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1028

How do you improve the performance of a SQL Azure Database?

137

How do I run sql server 2014?

980

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2014

what purpose does the model database serve? : Sql server database administration

971

What gets stored inside msdb database?

1244

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1058

What are the disadvantages of merge replication?

1410

What are the benefits and tasks of object explorer? : sql server management studio

1175

What is mssql?

980

What is a scheduled job or what is a scheduled task?

948

What is the security model used in sql server 2005?

999

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

986

What it means to be triggered?

991