how to get the third quarter of employee details from emp?
- 2 Answers
- 7360 Views
- CompuTech, I also Faced
- E-Mail Answers
Answer Posted / eshwer
select * from emp where TO_CHAR(hiredate,'Q')=3;
'Q' Regrives the all the 4 quarters(1,2,3,4) details on
that we retrive the 3 quarter details
Please check it
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What mean sql?
What is the use of non clustered index?
What is the difference between the conventional and direct path loader? : aql loader
Does pl/sql support create command?
What are field types?
Show code of a cursor for loop.
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the difference between delete and truncate commands?
Why is pl sql needed?
what is a database? : Sql dba
Can pl sql procedure have a return statement?
What is a temp table?
What does pl sql developer do?
what are all the common sql function? : Sql dba
What is rownum in sql?
