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
3798 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 do you explain an index number?

1079

Write the alter statement to enable all the triggers on the t.students table.

1110

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3036

How do I debug a stored procedure?

1093

What is foreign key sql?

973

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

989

How do I save a sql query?

1000

how to enter characters as hex numbers? : Sql dba

1024

How do you select unique values in sql?

980

What is a primary key? Explain

960

What are the different types of dbms?

994

What is function and procedure in pl sql?

1025

What is a dynamic query?

1007

what are sequences

1721

Why join is faster than subquery?

1092