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??
Answer Posted / krishna
This Query shall do the trick.
SQL> desc a;
Name Null? Type
------------------------------- -------- ----
A NUMBER(2)
SQL> select * from a;
A
---------
1
5
7
SQL> select x from (
2 select rownum x from all_tables ) a, (select max(a)
mx, min(a) mi from a) b
3 where a.x between b.mi and b.mx
4 and a.x not in (select * from a)
5 /
X
---------
2
3
4
6
SQL>
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are system versioned tables?
What are pl/sql cursor exceptions?
differentiate between float and double. : Sql dba
Which is better join or inner query?
What is substitution variable in pl sql?
Define select, insert, create, delete, update, drop keywords
Does sql between include endpoints?
What makes a good primary key?
Is merge a dml statement?
What are sql indexes?
What does (+) mean in sql joins?
Can we use update in sql function?
How much does sql certification cost?
How show all rows in sql?
How to rename a column in the output of sql query?