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 / 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 the difference between null value, zero, and blank space?
What is sql procedures and functions?
Why is stored procedure faster than query?
What are the various restrictions imposed on view in terms of dml?
What are analytic functions in sql?
What are the 3 modes of parameter?
Does sql*plus have a pl/sql engine?
Can we insert data into materialized view?
How can I speed up sql query?
what are all the different types of indexes? : Sql dba
what are the different type of sql's statements ? : Sql dba
What is varchar sql?
Can we alter stored procedure?
What is union, minus and interact commands?
What is the difference between partition and index?