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
7947 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

When can we use the where clause and the having clause?

1022

What is an implicit commit?

1058

Is sql easier than java?

1020

What are the types of index in sql?

1071

How many sql statements are used?

1017

what is a stored procedure? : Sql dba

1140

What is a file delimiter?

1101

explain advantages of myisam over innodb? : Sql dba

1071

What is group by in sql?

1089

What is sql injection owasp?

1070

What is the use of desc in sql?

980

how can we know the count/number of elements of an array? : Sql dba

1066

What are the types of operators available in sql?

1070

How does left join work in sql?

1008

What are secondary keys?

976