Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Why is nosql good?

0 Answers  

What is a transaction?

5 Answers  

Where is pl sql used?

0 Answers  

Which sql statement is used to return only different values?

0 Answers  

What are variables in pl sql?

0 Answers  

how to select unique records from a table? : Sql dba

0 Answers  

What is procedure explain with program?

0 Answers  

what is sql.

7 Answers   Ericsson, Hewitt,

Why does %isopen return false for an implicit cursor?

1 Answers  

Does a user_objects view have an entry for a trigger?

0 Answers  

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

For more SQL PLSQL Interview Questions Click Here
Categories