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

Answer / vikas kant

select key,count(key1) from [table_name]
group by key

Answer / hanamesh havale

select top 10 cast(key as varchar)
+ '(' + cast(count(key) as varchar) + ')'
from TableName
group by key


Hanamesh Havale
Influx Infotech

Answer / saravanan p

Select cast(idKey as varchar)+'('+cast(count(idKey) as
varchar)+')'
from #tbl1 group by idKey

Answer / pradip jain

select convert(varchar,key) + '('+ convert(varchar,
count(key))+')' from table_name group by key

Hanamesh, why top 20?

Answer / neeraj

If the column name is key
select key,count(*) from jojo
group by key

simple

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;

Answer / rakesh prasad

In Sql server 2005

select col + '('+ cast (count(col)as varchar(1000))+')'from
tablename group by col

Answer / guest

3

Answer / manju

select key,count(key)as"count of items" from tablename
group by key order by key

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

please differentiate between delete and truncate?

0 Answers  

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

How to define output parameters in stored procedures?

0 Answers  

How to create an multi-statement table-valued function?

0 Answers  

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

What are the differences between clustered and non-clustered index?

0 Answers  

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

What is standby servers? Explain types of standby servers.

0 Answers