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
- 8989 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / kavitha n
Create Table Missingsquence ( Num Number);
sql > select Num from Missingsquence ;
Missingsquence
--------------
1
5
7
SELECT LEVEL num
FROM DUAL
CONNECT BY LEVEL <= 7
MINUS
SELECT num
FROM missingsquence;
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is difference between left and right outer join?
Explain how can you save or place your msg in a table?
Explain 3 basic parts of a trigger.
what are the differences between char and varchar? : Sql dba
What is localdb mssqllocaldb?
What are character functions?
How many tables can a sql database have?
How do I truncate a sql log file?
How do I debug a stored procedure?
What is consistency?
What is the need of merge statement?
What is the best sql course?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What does the hierarchical profiler does?
How can you load microsoft excel data into oracle? : aql loader
