1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / praveengnr

Answers were Sorted based on User's Feedback



i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query t..

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

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query t..

Answer / malthesh sagar

select count(acnt_type),acnt_type from a
group by acnt_type;

Is This Answer Correct ?    10 Yes 2 No

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query t..

Answer / ramesh

Select count(id), accnt_type from Account
group by accnt_type;

Is This Answer Correct ?    1 Yes 0 No

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query t..

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

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query t..

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

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query t..

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

Post New Answer

More SQL PLSQL Interview Questions

How can a function retun more than one value in oracle with proper example?

1 Answers  

How do you delete duplicates in sql query using rowid?

1 Answers  

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

what is column? : Sql dba

1 Answers  

Why truncate is used in sql?

1 Answers  

Does sql support programming?

1 Answers  

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1 Answers  

What is the use of desc in sql?

1 Answers  

what is foreign key? : Sql dba

1 Answers  

How to start the command-line sql*plus?

1 Answers  

What is the best sql course?

0 Answers  

What is a database event trigger?

1 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories