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
13868 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 is record data type?

916

How many tables can a sql database have?

977

Can a view be mutating? If yes, then how?

1027

What is error ora-01000: maximum open cursors exceeded

1146

where are cookies actually stored on the hard disk? : Sql dba

1030

Name some usages of database trigger?

1020

What is user defined functions?

981

If a cursor is open, how can we find in a pl/sql block?

1167

What are field types?

1005

what are numeric data types? : Sql dba

1061

Why is pl sql needed?

943

How do you add a column to a table?

1055

What is Histogram?

1558

Is a view faster than a stored procedure?

970

Can we rollback truncate?

998