Answer / shivainduja

Select count(*), accnt_type from Account where accnt_type in
(FD,SAVING,RD) group by accnt_type;

Answer / malthesh sagar

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

Answer / ramesh

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

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'

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;

Answer / ambika

in FD,SAVING &RD..MOST PEOPLE..ARE JOINING BUT MORE PEOPLE
ARE JOINING SAVING BANK A/C ONLY

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

What is the difference between a subquery and a join?

0 Answers  

How do I truncate a sql log file?

0 Answers  

Why trigger is used in sql?

0 Answers  

What is the current version of postgresql?

0 Answers  

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

Explain what is a view?

0 Answers  

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

Is join same as left join?

0 Answers  

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,