Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3807 Views
- Maruti Suzuki, I also Faced
- E-Mail Answers
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 are keys in sql?
Is primary key a clustered index?
What is the use of non clustered index?
How sql query is executed?
What is blind sql injection?
Where is pl sql used?
How do you use join?
how to drop an existing table in mysql? : Sql dba
Explain normalization and what are the advantages of it?
What is column?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
what is a join? : Sql dba
Why use triggers in sql?
How do you update a value in sql?
Why does sql need a server?
