how to get the third quarter of employee details from emp?
Answer Posted / 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 View All Answers
What is the difference between a query and a report?
what is view? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
what is a join? : Sql dba
What are aggregate and scalar functions?
How do you write a complex sql query?
What is indexing oracle sql?
Is microsoft sql free?
Explain commit, rollback and savepoint.
Can we create a trigger on view?
How to write html code in pl sql?
What is a ddl command?
what is the use of friend function? : Sql dba
what is a control file ? : Sql dba
How do I copy a table in sql?