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 |
difference between pl/sql table and normal pl/sql table
What is difference between stored procedures and application procedures?
What does select * from mean in sql?
What is the difference between local and global temporary table?
real time applications of nullif?
How to revise and re-run the last sql command?
How do you delete data from a table?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What normalization means?
What are the limitations of sql express?
What is Temp Table and type of temp table?
Which kind of parameters cannot have a default value in pl sql?