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
How do I copy a table in sql?
How many clustered indexes can be created on a table?
Can a table contain multiple foreign key’s?
Can we use ddl commands in pl sql?
What is sqlcontext?
What is the difference between left join and right join?
What are different methods to trace the pl/sql code?
Which is better cte or subquery?
What is the process of copying data from table a to table b?
What is equi join in sql?
What are user defined functions?
how to calculate expressions with sql statements? : Sql dba
What is data manipulation language?
What is a database event trigger?
Write a query to display the current date in sql?