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.
- 2 Answers
- 3175 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
What is trigger price?
How would you reference column values before and after you have inserted and deleted triggers?
What if we write return in procedure?
What are the different types of sql commands?
What is the difference between a subquery and a join?
What is rowid in sql?
what is 'mysqlshow'? : Sql dba
Show code of a cursor for loop.
What is update query?
What is forward declaration in pl sql?
What are different functions in sql?
how to drop an existing table in mysql? : Sql dba
What is denormalization in a database?
Why do we use triggers?
How to return multiple rows from the stored procedure?
