table name: prod there are three fields in the table that are 1.proddate 2.p

table name: prod there are three fields in the table that are
1.proddate
2.prodQty
3.model
Day wise prodQty is stored in the table prod
write a query to display total prodqty in the year 2004 april.

Question Posted / neetu

2 Answers
3943 Views
Maruti Suzuki, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day..

Answer / ajit

SELECT SUM(PRODQTY) FROM EMP WHERE TO_CHAR(PRODDATE,'MON-YYYY')='APR-2014';

Is This Answer Correct ?

1 Yes

0 No

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day..

Answer / sunnil

select sum(prodqty) from emp where to_char('proddate','yyyy')=2014 and to_char('proddate','mm')=04;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

find the third highest salary?

23 Answers

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers

Which data type is a composite type?

0 Answers

What does count (*) mean?

0 Answers

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers Oracle,

How do I partition a table in sql?

0 Answers

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers Fintellix,

What are indexes, and what are the different types?

3 Answers

What do you mean by query optimization?

0 Answers

Can one improve the performance of sql*loader? : aql loader

0 Answers

Explain the purpose of %type and %rowtype data types?

0 Answers

Why do we need pl sql?

0 Answers

For more SQL PLSQL Interview Questions Click Here