select rownum from dual connect by level <= (select max(a) from mising

suppose we have values like 1 5 7 in a colum.Now we want
numbers like(2 3 4 6) that exists between 1 5 7.How can we
do this using sql query??

Question Posted / ajitnayak

Answer Posted / ajitnayak

select rownum
from dual
connect by level <= (select max(a) from mising_values)
minus
select * from mising_values;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do we use distinct statement? What is its use?

975

What is coalesce in sql?

970

What are literals in sql server?

1071

How do I count rows in sql query?

937

How do you get column names only for a table (sql server)?

1100

What are sql commands?

935

Is primary key an index?

945

what is a cursor? : Sql dba

972

what is csv? : Sql dba

945

Why join is faster than subquery?

1042

What is the sql case statement?

951

What are pl/sql cursors?

989

What is join view in sql?

896

Which constraints we can use while creating database in sql?

1015

what is the difference between delete and truncate statement in sql? : Sql dba

1127