select * from emp where TO_CHAR(hiredate,'Q')=3; 'Q'

how to get the third quarter of employee details from emp?

Question Posted / eshwer

2 Answers
7913 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

Please Help Members By Posting Answers For Below Questions

What found sql?

941

What is a primary key example?

956

how mysql optimizes distinct? : Sql dba

1076

What are the disadvantages of not performing database normalization?

1158

Why join is faster than subquery?

1107

what are set operators in sql? : Sql dba

1049

How to test for null values?

1044

What is a recursive stored procedure?

1177

How show all rows in sql?

1011

What is field delimiter?

1042

How many sql commands are there?

1114

What is the purpose of my sql?

946

What is pls_integer in pl sql?

1103

Is oracle sql free?

982

How to run sql*plus commands in sql developer?

1151