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
- 8990 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / ajitnayak
select rownum
from dual
connect by level <= (select max(a) from mising_values)
minus
select * from mising_values;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain clause in sql?
What is synchronized subquery?
What is a sql profiler?
What is a heap in sql?
What is the unique index?
What is difference between nchar and nvarchar?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How do you take the union of two tables in sql?
What is the mutating table and constraining table?
what are all different types of collation sensitivity? : Sql dba
What is the meaning of disabling a trigger?
What are all the ddl commands?
How do you modify a table in sql?
Is truncate ddl or dml?
What is a data manipulation language?
