1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / surya

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / rupesh kumar

select * from emp where rownum<=(select round((count(*)/4)
*3) from emp)
minus
select * from emp where rownum<=(select round((count(*)/4)
*2) from emp)

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What is cost in sql execution plan?

0 Answers  

Explain what is table in a database?

0 Answers  

How do you truncate?

0 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

Which normal form is best?

0 Answers  




How to call a javascript function from pl sql?

0 Answers  

Can we join two tables without common column?

0 Answers  

What are system versioned tables?

0 Answers  

What is using in sql?

0 Answers  

What is flag in sql?

0 Answers  

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

what is the order of pre-defined exceptions.

6 Answers   TCS,

For more SQL PLSQL Interview Questions Click Here
Categories