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
3816 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

Are stored procedures faster than dynamic sql?

1024

Is sql open source?

966

Is crud a cuss word?

1027

What is pivot query?

1064

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1059

Explain normalization and what are the advantages of it?

947

What are different types of indexes?

1003

describe transaction-safe table types in mysql : sql dba

998

What is sqlerrm?

927

Why is sql better than hql?

976

What is posting?

1032

What is schema in sql?

941

Which language is used in sql?

1049

How many sql commands are there?

1110

How many types of privileges are available in sql?

1338