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
How do you update sql?
What is the difference between delete and truncate statement in sql?
What are the advantages of sql?
Mention what are different methods to trace the pl/sql code?
What are primary key and foreign key and how they work?
Is pl sql and postgresql same?
How do I view tables in sql developer?
How do I send sql query results to excel?
What is rename in sql?
How to create an array in pl/sql?
What does trigger mean in psychology?
How does cross join work in sql?
What are its different types of dbms?
What is a sql schema used for?
What does plv msg allows you to do?