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

Is coalesce faster than isnull?

907

Is sql microsoft?

977

Explain lock escalation? : Transact sql

1142

What is bitemporal narrowing?

1231

How can one get sql*loader to commit only at the end of the load file? : aql loader

1004

What is error ora-12154: tns:could not resolve the connect identifier specified?

1016

when MSQL8.0 is in market

2014

Is foreign key mandatory?

938

What is sequence in sql?

938

Explain 3 basic parts of a trigger.

1255

What is pls_integer in pl sql?

1030

What are the events on which a database trigger can be based?

1101

What are the different types of tables in sql?

929

Can we create index on primary key?

914

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1043