Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the third quarter of employee details from emp?
- 2 Answers
- 7935 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
what are the difference between clustered and a non-clustered index? : Sql dba
What is a database event trigger?
Why select is used in sql?
What are the different type of joins in sql?
what are the properties and different types of sub-queries? : Sql dba
How we can update the view?
What is minus?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
what is oracle database ? : Sql dba
what are the limitations of identity column? : Transact sql
What are the types of triggers in sql?
What does trigger mean in psychology?
What is the difference between inner join and natural join?
What is date functions?
