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 to create dbo table in sql server?

0 Answers  

Do you know what is rank function?

0 Answers  

What is create statement?

0 Answers  

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

What are the database roles? : sql server security

0 Answers  

What are the 7 disadvantages to a manual system?

0 Answers  

How to include date and time values in sql statements?

0 Answers  

List some advantages and disadvantages of stored procedure?

0 Answers  

How do I create a stored procedure in sql server?

0 Answers  

What are the advantages of using stored procedures in sql server?

0 Answers