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
18599 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 will you find out if there are expensive SQL statements running or not?

978

How do you delete duplicate records in sql server?

1008

Explain how to send email from sql database?

984

Can multiple columns be used in sql group by clause in ms sql server?

1001

Suggest a method of joining two tables.

1110

Explain why variables called the most powerful component of ssis?

1006

List the data types available in mssql?

971

What is log ldf?

940

What is difference between after and before?

1003

What is default constraint in ms sql server?

971

What is subquery explain with example?

1014

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1040

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1837

What is rolap and its advantage? : sql server analysis services, ssas

1229

What is microsoft sql server?

920