If a table T1 has single column c1 with data base
(a,a,b,b,b,c)
write a query that out put as follows

c1 count (c1)

Answer Posted / suraj

select c1,count(c1) from T1
group by c1;

Is This Answer Correct ?    31 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

frnds it took 7trs for me to complete my btech [ece] due to some financial problms...am i eligible to do masters in foreign trade pls advice me...

1410


i got job from icici bank as an PO and as a clerk in canara bank. which one is best to choose..

1791


When will axis bank announce the result of exam held on 20th june 2010 of western zone?

1730


WAHT IS GENERAL ADMINISTRATION ?

1548


as i have two rejections on my passport is this affect my approval for visa and whether they will ask me any questions related to past interview done plz inform me soon as my interview is on 20 july

1529






where can i find original all ved and purans?

1458


what is the general administration

1596


The distance between the magnetic north pole and magnetic south pole of a bar magnet is called the...?

1391


What is mean by stacking?

1480


what is the type of supply((AC or DC) used to HT motors?

1523


what is the time alloted for objective question in allahbad bank clerical exam.plz answer.

1859


why do pharma companies are not having only pharmacists to work rather than they can recruit others

1588


waht is your srength and weakness?

1772


where did the name "cat" come from?

1838


what is mean by domain interms of software ? can you expain in specific in terms of web based , networking all those ?how to choose the domain for doing a project in software feild ?

1519