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 sql not null constraint?
what are the advantages of sql ? : Sql dba
What are transaction and its controls?
How many rows can sqlite handle?
What is meant by truncate in sql?
what are tables and fields? : Sql dba
What is auto increment feature in sql?
Is oracle sql free?
Which command is used to delete a trigger?
Is it possible to update views?
What do you understand by exception handling in pl/sql?
What is view explain with example?
How many types of sql are there?
How do I run a sql query?
Can you call pl/sql package functions from within a fast formula?