Sign Up Login


  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

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

How can I pass the inner procedure value to outer procedure ?

2 Answers  

What is meant by <> in sql?

0 Answers  

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  

What is a procedure in pl sql?

0 Answers  




Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

What is data control language?

0 Answers  

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

what is a cursor

9 Answers   IBM, TCS, Wipro,

What is rank () in sql?

0 Answers  

What is cursor status?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories