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

dear sir , how i prepare general studies of rbi .

0 Answers   RBI,


How does volunteering helps to enrich the resume and help to build the skills?

1 Answers  


how to count pelindrome word from string???? give answer in c language!!!!

0 Answers  


I am about to appear for Exam in Central bank of india for probationary officer.Could yo suggest me a book n also i need a few model questions

0 Answers  


why are you suitable for national physical laboratory?

1 Answers  






From where you got newly launched nokia mobile i.e. "Nokia Astound" at lowest price?

1 Answers   T Mobile,


Sir, I have completed my BTech in Electronics and Communication and also MTech in Nanoscience .But I want to come in the banking sector. What are the questions expected in interview ? plz help

0 Answers   State Bank Of India SBI,


what exactly will be group1 interview

0 Answers  


I want sylabs of cleark test of H A U HISAR

0 Answers  


why governor is not provided with the power to pardon death sentence..

0 Answers  


------------ 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?

0 Answers  


tell me about yourself ?

0 Answers  


Categories