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
13822 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 different types of sql commands?

1110

How to check if a column is nullable before setting to nullable?

1120

Explain what is an index?

1052

How do I view a view in sql?

947

How can you create an empty table from an existing table?

1073

What is pls integer?

1031

What is the sql case statement?

993

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1063

What is secondary key?

932

Explain the advantages and disadvantages of stored procedure?

1140

explain the options of myisamchk to improve the performance of a table. : Sql dba

1004

Why do we need databases?

1036

What is procedure explain with program?

1013

What is the difference between sql and mysql?

1115

What are hotfixes and patches?

941