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

what is a relationship and what are they? : Sql dba

1101

What do you understand by pl/sql cursors?

1090

Is sql a backend language?

1100

Which nosql database is best?

979

Can we rename a column in the output of sql query?

995

Name three sql operations that perform a sort.

1018

What are the key differences between SQL and PL SQL?

1217

Can we join two tables without common column?

1010

When is the explicit cursor used ?

1038

What plvcmt and plvrb does in pl/sql?

1323

what is sql profiler? : Sql dba

1048

Why is nosql good?

1029

What is string data type in sql?

1146

Does oracle roll back the transaction on an error?

1015

Does user triggers have entry for trigger with compilation errors?

1038