Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mousumi dalai
select min(sal) from emp where sal in
( select sal from
(select sal from emp order by sal desc)
where rownum<=3)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
List and explain the different types of join clauses supported in ansi-standard sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How subquery works in sql?
what are the features and advantages of object-oriented programming? : Sql dba
Is a foreign key always unique?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Does sqlite need a server?
what are the different index configurations a table can have? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How many primary keys can a table have?
What packages are available to pl/sql developers?
Why do we need pl sql?
explain the delete statements in sql
What is Materialized View? In What Scenario we Use Materialized View?
Define a temp table?
