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
when MSQL8.0 is in market
Why stored procedure is faster than query?
How does sql developer connect to oracle database?
Why is a trigger used?
how to present a past time in hours, minutes and seconds? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What are variables in pl sql?
what is the difference between primary key and unique key? : Sql dba
What is the difference between inner join and outer join?
What is using in sql?
Is sql easier than java?
How can we link a sql database to an existing android app?
What operating systems are supported by oracle sql developer?
What are character functions?