Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the third quarter of employee details from emp?
- 2 Answers
- 7953 Views
- CompuTech, I also Faced
- E-Mail Answers
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
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
How does a trigger work?
What are triggers and its uses?
Is left join faster than join?
what is 'mysqldump'? : Sql dba
How can we store rows in PL/SQL using array?
What is the difference between left and left outer join?
What are stuff and replace function?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
what are the advantages of mysql in comparison to oracle? : Sql dba
How do you know if a relationship is 2nf?
Why is sql important?
Why do we go for stored procedures?
What packages are available to pl/sql developers?
