Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9897 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 single byte over head in oracle..?
What does := mean in pl sql?
Is pl sql a scripting language?
How do you take the union of two tables in sql?
How to read xml file in oracle pl sql?
how to start mysql server? : Sql dba
what is a constraint? : Sql dba
Explain lock escalation? : Transact sql
Explain what is dbms?
What is foreign key and example?
What is a constraint? Tell me about its various levels.
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Can we use joins in subquery?
Are sql connections encrypted?
Why is partition used in sql?
