Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh
select sal from emp e
where 100=(select count( distinct sal) from emp where
e.sal<=sal)
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is bulk compiling in pl/sql.?
What is difference between cursor and trigger?
Are stored procedures faster than queries?
Does sql*plus also have a pl/sql engine?
Can we create table inside stored procedure?
What is indexing oracle sql?
What is compiled query?
Why do we use triggers?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I remove duplicates in two columns?
Define overloaded procedure?
What is the difference between cross join and natural join?
explain access control lists. : Sql dba
Can I learn sql in a week?
what is sql server agent? : Sql dba
