Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 13870 Views
- Fidelity, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Inline the values in PL/SQL, what does it mean.?
How can you select unique records from a table?
Why is stored procedure faster than query?
What is materialized view. What are different methods of refresh?
How many times can we commit in a loop?
What is sql query optimization?
What is execution plan in sql?
What is coalesce in sql?
What is embedded sql with example?
Is there any restriction on the use of union in embedded sql?
What is sql profiler in oracle?
Explain scalar functions in sql?
How to write pl sql program in mysql command prompt?
What are the different schemas objects that can be created using pl/sql?
What is java sql driver?
