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??
- 5 Answers
- 8988 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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 is the difference between jpql and sql?
Why is stored procedure faster than query?
What are procedures used for?
How do you determine the current isolation level? : Transact sql
How many sql statements are used?
how many values can the set function of mysql take? : Sql dba
How do I start sql from command line?
What is rank () in sql?
What is the difference between sql and t sql?
What is dbo in sql?
Is sql a case sensitive language?
how to extract a unit value from a date and time? : Sql dba
How do you use collections in procedure to return the resultset?
What is the purpose of the sql select top clause?
Define implicit and explicit cursors.
