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

Show the two pl/sql cursor exceptions.

1189

How do you update a value in sql?

1043

Can a table contain multiple foreign key’s?

992

What is union, minus and interact commands?

1288

What is foreign key in sql with example?

929

What is on delete restrict?

1000

Is hadoop a nosql?

997

What is difference between ms sql and mysql?

959

Explain 3 basic parts of a trigger.

1314

Differentiate pl/sql and sql?

1062

What is dynamic query?

969

What is the file extension for sql database?

997

What is primary key and unique key?

1116

what is sql profiler? : Sql dba

1038

Is merge a dml statement?

975