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
- 3329 Views
- Maruti Suzuki, I also Faced
- E-Mail Answers
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 does the base_object_type column shows in the user.triggers data dictionary view?
What are the different types of sql commands?
What is pl sql code?
Why are aggregate functions called so?
What can you do with pl sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How can check sql version from command line?
Does sap use sql?
how to enter numeric values as hex numbers? : Sql dba
What is not in sql?
what are the 'mysql' command line options? : Sql dba
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Can we edit a view in sql?
How can we solve sql error: ora-00904: invalid identifier?
Why join is faster than subquery?
