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
Mention what are different methods to trace the pl/sql code?
What is Collation Sensitivity ? What are the various type ?
How can we optimize a sql query?
What is denormalization in a database?
Is a foreign key always unique?
What are conditional predicates?
define sql insert statement ? : Sql dba
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Define the select into statement.
Can we rollback after truncate?
What is pl sql in dbms?
What is varray in pl sql?
How is indexing done in search engines?
Write a sql query to find the names of employees that begin with ‘a’?
Does normalization improve performance?