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

What is normalization sql?

1060

What are commit, rollback, and savepoint?

995

What are aggregate functions in sql?

1161

Write a query to find the names of users that begin with "um" in sql?

996

what is rollback? : Sql dba

1111

How many types of keys are there in sql?

1039

What is the difference between sql and mysql?

1118

Can I join the same table twice?

1045

how can we destroy the cookie? : Sql dba

1011

how to drop an existing view in mysql? : Sql dba

1061

Enlist some predefined exceptions?

1060

what is oltp (online transaction processing)? : Sql dba

1077

Mention what does the hierarchical profiler does?

1091

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1043

Can cursors be part of a trigger body?

1641