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
3739 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 built in functions of sql?

999

How show all rows in sql?

989

What is sql used for?

1082

What is the difference between having and a where in sql?

1054

What are the different dcl commands in sql?

1095

What is foreign key and example?

902

Why triggers are used?

950

What is the difference between a database and a relational database?

1058

What is insert command in sql?

1084

What is pls integer?

1001

How many disk partitions should I have?

959

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1135

What is the need of a partition key?

958

What is pl sql in dbms?

918

how to get a list of columns in an existing table? : Sql dba

928