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

List and explain the different types of join clauses supported in ansi-standard sql?

1400

What is union, minus and interact commands?

1363

How do you remove duplicate records from a table?

979

What is sap sql anywhere?

1163

Why are indexes and views important to an organization?

996

What is the difference between function and procedure in pl/sql?

1135

What is mutating trigger?

1071

What is right join in sql?

1153

How to make a copy values from one column to another in sql?

1080

What is sql comments?

1116

What is a record in a database?

1102

What is the sql query to display the current date?

1092

What is audit logout in sql profiler?

1073

What is meant by cursor in sql?

1061

What is on delete set null?

1135