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

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 / ajit

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

Answer Posted / ajit

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to concatenate two character strings? : Sql dba

1157

Which is better trigger or stored procedure?

1014

What are different clauses used in sql?

1172

How do I find duplicates in sql?

980

What is schema in sql?

998

What does over partition by mean in sql?

1039

How do I upgrade sql?

1048

Why is a trigger used?

991

What is sql architecture?

1102

How can I tell if sql is running?

1131

How many joins can you have in sql?

988

Explain what is a subquery ?

1242

Why we use triggers in mysql?

1037

Mention what pl/sql package consists of?

1041

What is prepared statement in sql?

1100