select count(acnt_type),acnt_type from a group by acnt

i have a table with fields(id,name,accnt_type)and in account
type are FD,SAVING,RD. Write a query to get How many number
of People are in each type of Account?

Question Posted / malthesh sagar

6 Answers
13617 Views
Fidelity, IBM, I also Faced
E-Mail Answers

Answer Posted / malthesh sagar

select count(acnt_type),acnt_type from a
group by acnt_type;

Is This Answer Correct ?

10 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is procedure explain with program?

949

Can we call procedure in select statement?

970

How can we find duplicate records in a table?

887

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2167

how can we destroy the session, how can we unset the variable of a session? : Sql dba

932

What is the use of sql trace?

892

How do I start sql from command line?

961

Is sql microsoft?

976

What is the most important ddl statements in sql are?

941

Do prepared statements prevent sql injection?

896

what is sql profiler? : Sql dba

994

what are the differences among rownum, rank and dense_rank? : Sql dba

976

what is an index? : Sql dba

924

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3923

What is anonymous block in sql?

1070