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

Explain autonomous transaction.

1154

How do you write a subquery?

1026

what is recursive stored procedure? : Sql dba

986

What are the types of join in sql?

1103

Does truncate table reset auto increment?

992

What are some predefined exceptions in pl/sql?

1167

what is a constraint? Tell me about its various levels. : Sql dba

986

What is native sql query?

1019

How much does sql certification cost?

1089

Can we create table in function?

964

Why use truncate instead of delete?

1016

what is the syntax for using sql_variant_property? : Transact sql

1044

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

What are the advantages of sql? Explain

1106

what are the t string functions available in tsql? : Transact sql

1008