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

Can we use views in stored procedure?

994

How to sort the rows in sql.

1022

What are the types of join in sql?

1046

What is a mutating table and a constraining table?

1061

what is the syntax for using sql_variant_property? : Transact sql

1003

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1084

Why do you partition data?

983

Which are the different character-manipulation functions in sql?

1013

Can we rollback after truncate?

1000

What company owns postgresql?

979

Is sql free?

901

What is indexing in sql and its types?

1020

Explain select statements in sql?

1019

How do I create a sql script?

1069

What are all the different normalization?

1000