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
How many functions are there in sql?
Mention what plvcmt and plvrb does in pl/sql?
Explain foreign key in sql?
What is full form of rtm?
What are the types of join and explain each?
Is sql a programming?
Explain the steps needed to create the scheduled job?
What is a join?
How many types of functions are there in sql?
How do I clear the screen in sql plus?
What are the 3 modes of parameter?
What are %type and %rowtype for?
What is the process of copying data from table a to table b?
What is a sql select statement?
What will you get by the cursor attribute sql%rowcount?