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
- 13630 Views
- Fidelity, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Is it possible to update views?
Is sql sequential or random?
how many triggers are allowed in mysql table? : Sql dba
What is a table?
Explain the purpose of %type and %rowtype data types?
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 is a database? Explain
What are the various levels of constraints?
When is a declare statement required?
How do you get column names only for a table (sql server)?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
How do I make sql search faster?
what are the different index configurations a table can have? : Sql dba
Is pl sql useful?
