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
3937 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 is before and after trigger?

1010

Is stored procedure faster than query?

1018

What is triggering circuit?

1105

What is pl sql variable?

1034

Can we change the table name in sql?

1000

What are expressions?

1062

How do I quit sql?

1005

What are the three pl sql block types?

1049

Which query operators in sql is used for pattern matching?

1009

What are the ddl commands?

1055

Why do we use procedures in sql?

1138

How to handle bulk data?

1364

What is update query?

1031

How can one get sql*loader to commit only at the end of the load file? : aql loader

1115

Are stored procedures faster than queries?

990