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

What is the importans of colums in Accession register?

1760


I am serving as bank office in mmgs all grade and I have applied for uppcs lower subordinate exam schedule on 6 april 2014 presently I am getting net salary of 34000 around ,what will be the net salary of uppcs lower subordinate and will it be good for me to leave the job of bank and join uppcs lower subordinate if selected.

1419


Hi Friends, One of my Friend is got selected in Karnataka Bank exam and He has to face interview so you if anybody has previous interview exp with karnataka bank could you please let us send expected interview questions. My special request friends if you know please let him know and help him out for get a success. send us mails at sreenivas.boddeti@gmail.com/santhosh_vegi@yahoo.com

1603


Rich man keeps me in the pocket poor man throws me away kids eat me its tamil word _u_e_l

1442


HI, i was given only 1st round and i made it through the first round, then was sent for the final HR round.In the HR round the HR manager dint ask me a single question of the related job,all he asked was as following:- i)what are your salary Expectations ii)are you ok to do night shifts.then he thanked me and said he will let me know by 2 days,when i asked him for any feedbacks and suggestions he said that he will let me know only after 2 days.SO please help me what shall i expect from this one of a kind interview. Many thanks in advance.

1523






------------ FINANCIAL MANAGEMENT: QUESTION: What will be your outlook towards maintenance of liquid assets to ensure that then firm has adequate cash in hand to meet its obligations at all times. HUMAN RESOURCE MANAGEMENT: QUESTION:The present state of recession in the IT industry – as a Human Resource Manager how are you going to undertake Human Resource Planning at Macro Level to tide over this crisis? MARKETING MANAGEMENT: QUESTION:If you are working in a supermarket, what are the tools / techniques you will use in data collection?How you are going to analyse this data and market inferences? How will you finally apply your marketresearch to improve sales and win over customers? ORGANIZATIONAL BEHAVIOUR: QUESTION:If you are made the campaign leader for particular party, how will you use your leadership skills to motivate your party men to ensure success of the party nominee in the elections (Focus on Individual, motivate and apply leadership style). PRINCIPLES AND PRACTICES OF MANAGEMENT: QUESTION: How will you influence people to strive willingly for group objectives in your organisation (target based industry)? Apply your interpersonal influence through communication process towards attaining your specialized goals? PRINCIPLES OF ECONOMICS: QUESTION:Suppose the price of elasticity of demand for text books is two and the price of the text book is increased by 10%. By how much quantity the demands fall? Inter the result and discuss reasons for the fall of quantity demand?

1557


Why you want to come in Marketing although you have done your MBA in Finance?

1576


can u list out shares in nifty from tamilnadu based companies

1639


what is core banking?

1782


 Tell me about a time when you had to use your presentation skills to influence someone's opinion

1778


tell me question of ssb??

1425


Dear Friends, Can any body provide RC Reddy study material for GROUP-II exams. Or can u plz tell me where can I get RC reddy Printed study material for Group-II. It would be highly appriciated if you provide me the details.

1521


the key persons of jallianwalla bagh massacre? who rendered vishnu sahasranamam in the form of casettes? which associate bank of sbi already merged n wich is going to merge? founder of andhra bank? reasons for selecting the banking sector?

1555


what an interviewer wants to see in the candidate.

1543


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

1478