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.
Answers were Sorted based on User's Feedback
Answer / ajit
SELECT SUM(PRODQTY) FROM EMP WHERE TO_CHAR(PRODDATE,'MON-YYYY')='APR-2014';
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Define concurrency control. : Transact sql
What are variables in pl sql?
how to escape special characters in sql statements? : Sql dba
Is left join and outer join same?
Does sql require a server?
What are different joins used in sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
HP Interview -2016 Unix 1) grep command in unix 2) what is set command
What is replication id?
How many types of triggers exist in pl/sql?
What is a sql statement?
What is dml and ddl?