Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the third quarter of employee details from emp?
- 2 Answers
- 7835 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
How to avoid duplicate records in a query?
What is clause?
What is difference between function and trigger?
What is trigger types in sql?
How many databases can sql express handle?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is a crud api?
Explain commit, rollback and savepoint.
What is sql and explain its components?
What is nested table in pl sql?
Is sql a scripting language?
Define commit, rollback and savepoint?
What is a unique constraint?
What is character functions?
what are the 'mysql' command line arguments? : Sql dba
