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

What is view explain with example?

940

How many types of index are there?

1048

What are the operators used in select statements?

1066

How do I run a pl sql procedure in sql developer?

982

What is your daily office routine?

2279

How to raise user-defined exception with custom sqlerrm ?

1140

Explain the uses of database trigger.

1121

What is sql server and ase?

1037

What is meaning of <> in sql?

1083

Does google use sql?

973

What is the difference between syntax error and runtime error?

1148

Explain what is a column in a table?

1118

What are triggers in sql?

1028

how to use 'mysql' to run sql statements? : Sql dba

1061

What are different types of queries in sql?

1128