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

What are the subsets of sql?

1135

how to run 'mysql' commands from a batch file? : Sql dba

1120

what are ddl statements in mysql? : Sql dba

1201

What is the use of <> sql?

980

What is trigger and how to use it in sql?

1021

How does a trigger work?

1075

What is the cause of mutating table error and how can we solve it?

1049

What are the advantages of normalization?

1078

Are stored procedures faster than queries?

948

Should I use mbr or gpt?

1026

what is sp_pkeys? : Transact sql

1159

What is execute immediate?

1085

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

Why is pl sql used?

984

How do we accept inputs from user during runtime?

1065