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
18489 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 candidate key with example?

922

How to end a stored procedure properly in ms sql server?

1016

What do you mean by collation recursive stored procedure?

1009

Explain what is the main purpose of having conversation group?

879

Describe in brief authentication modes in sql server.

966

Explain having clause and where clause?

988

What is a linked server in sql server?

1014

How much is a sql server license?

900

What is a full text index?

871

What are the new scripting capabilities of ssms? : sql server management studio

1000

what is dbcc? : Sql server database administration

965

What do you mean by authentication modes in sql server?

1027

In what version of sql server were synonyms released?

904

What are the different editions available in sql server 2000?

992

Why we need sql server?

910