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
Does mysql support pl sql?
how to use case expression? : Sql dba
What is rename command in sql?
How many times can we commit in a loop?
Is primary key a clustered index?
Can a view be mutating? If yes, then how?
How do I view a table in sql?
Can we use loop in sql?
What are some predefined exceptions in pl/sql?
How do I write a cron which will run a sql query and mail the results to agroup?
how to check myisam tables for errors? : Sql dba
What is sqlerrd?
How can we debug in PL/SQL?
what is the use of set statement in tsql? : Transact sql
What is the difference between mdf and ndf files?