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?
Answers were Sorted based on User's Feedback
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 |
Answer / malthesh sagar
select count(acnt_type),acnt_type from a
group by acnt_type;
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / ramesh
Select count(id), accnt_type from Account
group by accnt_type;
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
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 |
what are different types of collation sensitivity? : Sql dba
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
How do I run a program in pl sql?
What is difference between stored procedure and trigger?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
write the Sql query for creating database backup?
Can We write bulk collect statement in triggers?
Why do we use joins?
How can you tell the difference between an index and a view?
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,
how are mysql timestamps seen to a user? : Sql dba