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
3852 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 it possible to pass parameters to triggers?

1113

Can we call a function containing dml statements in a select query?

989

What is range partitioning?

976

What does select top 1 do in sql?

1105

what is bdb (berkeleydb)? : Sql dba

1040

Does access use sql?

1048

What is rename command in sql?

1043

What is rank function in sql?

1037

What is the difference between count 1 and count (*) in a sql query?

1002

Can we update views in sql?

944

Is ms sql traffic encrypted?

930

What is data manipulation language?

1194

Why do we use joins?

1051

What is sqlca in powerbuilder?

1028

Do we need to create index on primary key?

932