Select count(id), accnt_type from Account group by accnt

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 / ramesh

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

Answer Posted / ramesh

Select count(id), accnt_type from Account
group by accnt_type;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster joins or subqueries?

1036

what is the use of double ampersand (&&) in sql queries?

1227

What is partition by in sql?

1126

What is composite primary key in sql?

1043

Define commit, rollback and savepoint?

1081

How do I write a cron which will run a sql query and mail the results to agroup?

1029

What does seeding a database mean?

1015

How does rowid help in running a query faster?

1475

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1017

Is sql workbench free?

1044

Sql technical questions

1334

what is 'mysqlcheck'? : Sql dba

1063

Is full outer join same as cross join?

1013

What are the types of queries in sql?

1124

Can we use two order by clause in query?

1015