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)



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

Answer / suraj

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

Is This Answer Correct ?    31 Yes 2 No

Post New Answer

More Everything Else AllOther Interview Questions

8.why do you want to work here?

0 Answers   British Airways,


What is induction cooker useable stainless steel

0 Answers  


why do you want to join an ngo

4 Answers   Oxfam,


If I dont feign to have a disability, whether it be mental or physical, to get state money, or money from S.S.I but let the people who really need the money have it instead, such as children and severly disabled people. But choose to activley look every day for employment, but do not find employment and end up living on the streets because I can no longer pay my rent, at what point does it NOT become my fault? Is there a time when I should simply follow the rest of the people over the cliff?

1 Answers  


We want that when we type baishakh and drag the fill handle,Excel should produce jestha, Aashadh and so on.What will you have to set to do that ?

1 Answers  






The Earth has 6.2 billion people and almost no one lives 100 years. Suppose this longevity fact remains true. How do you know that some year soon, more than 50 million people will die.

0 Answers  


Is it right to leave TCS & join Accenture for 2 years experienced Software Professional ?

0 Answers  


How do you evaluate whether an SEO campaign is working?

1 Answers  


sir i got a call from cabinet secretariat regarding i got selected in dfo(gd) 2013 on 28/5/2016 to come for filling of some details in my interview attestation form,which i submitted.Now when will my verification be completed and got the appointment letter.Is anybody got the same

0 Answers   Cabinet Secretariat,


name the places where the indian govt has given its nod to set up four new tiger resereviors?

0 Answers  


Which is the most widely used spice in the world

4 Answers   NPL,


what are the causes of low productivity and poverty in least developed countries today? show how fully they affect those societies

0 Answers  


Categories