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?
Answers were Sorted based on User's Feedback
Answer / shivainduja
Select count(*), accnt_type from Account where accnt_type in
(FD,SAVING,RD) group by accnt_type;
Is This Answer Correct ? | 30 Yes | 6 No |
Answer / malthesh sagar
select count(acnt_type),acnt_type from a
group by acnt_type;
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / ramesh
Select count(id), accnt_type from Account
group by accnt_type;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / saurabh agarwal
SELECT COUNT(*) FROM ACCOUNT WHERE ID IN(SELECT ID FROM
ACCOUNT WHERE ID IN( SELECT ID FROM ACCOUNT WHERE
ACCNT_TYPE ='FD') AND WHERE ACCNT_TYPE ='SAVING') AND
ACCNT_TYPE='RD'
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / jithu
Select count(accnt_type), accnt_type from Account where
accnt_type in
(FD,SAVING,RD) group by accnt_type having count(accnt_type)>0;
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ambika
in FD,SAVING &RD..MOST PEOPLE..ARE JOINING BUT MORE PEOPLE
ARE JOINING SAVING BANK A/C ONLY
Is This Answer Correct ? | 0 Yes | 2 No |
What is informix sql?
difference between anonymous blocks and sub-programs.
what are all the common sql function? : Sql dba
What are the advantages of indexing?
what is oltp (online transaction processing)? : Sql dba
What is data types in sql?
how to create a new view in mysql? : Sql dba
What is the difference between syntax error and runtime error?
why not null constraint showing its constraint type as 'c'
What are different types of sql commands?
How to call DDL statements from pl/sql?
Does truncate free space?