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.
Answer Posted / ajit
SELECT SUM(PRODQTY) FROM EMP WHERE TO_CHAR(PRODDATE,'MON-YYYY')='APR-2014';
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is cursor and its types?
What is a composite primary key?
What is consistency?
how to calculate the difference between two dates? : Sql dba
How is sql used in oracle?
Can a trigger call a stored procedure?
What is sql procedures and functions?
How can I change database name in sql?
How do I use google cloud in sql?
What is prepared statement in sql?
Can we delete column in sql?
What is the difference between view and stored procedure?
How do you clear the screen in sql?
What is cursor and why it is required?
What is benefit of creating memory optimized table?