SELECT COUNT(*) FROM ACCOUNT WHERE ID IN(SELECT ID FROM ACCOUNT WHERE ID

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 / saurabh agarwal

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are null values? : Sql dba

1013

What is the use of function in sql?

1150

What are all the ddl commands?

1242

how many triggers are allowed in mysql table? : Sql dba

1102

what is recursive stored procedure? : Sql dba

1027

what is the command used to fetch first 5 characters of the string? : Sql dba

1682

what is a constraint? Tell me about its various levels. : Sql dba

1047

How much ram can sql express use?

1040

Give the order of sql select?

1185

How delete all data from all tables in sql?

985

What are tables and fields in the database?

1188

What are the three pl sql block types?

1049

what is a view? : Sql dba

1132

Does view contain data?

1084

Why is sql important?

1170