select sum(prodqty) from emp where to

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 / sunnil

2 Answers
3704 Views
Maruti Suzuki, I also Faced
E-Mail Answers

Answer Posted / sunnil

select sum(prodqty) from emp where to_char('proddate','yyyy')=2014 and to_char('proddate','mm')=04;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do prepared statements prevent sql injection?

898

How much does sqlite cost?

986

Difference between global and parameter variables?

1908

How are functions and procedures called in PL/SQL?

1132

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1135

what are null values? : Sql dba

902

What is db journal file?

956

Which command is used to call a stored procedure?

954

What is the use of non clustered index?

930

What is lookup table in sql?

982

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4096

What are secondary keys?

923

Why do we use view in sql?

910

What are sql functions? Describe in brief different types of sql functions?

1013

What is a loop in sql?

937