Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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??

Question Posted / msmonika13

Answers were Sorted based on User's Feedback



suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between..

Answer / 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

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between..

Answer / 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

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between..

Answer / elumalai d

--QUESTION36:-What is different between union and minus?

UNOIN:- it returns all the records from both tables without duplicates.
Example:-
A={1,2,3,4}
B={2,3,4,5,6}
AUB={1,2,3,4,5,6}

CREATE TABLE question36 (empid NUMBER);
CREATE TABLE quest36 (empid NUMBER);

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(4);
INSERT INTO quest36 VALUES(5);
INSERT INTO quest36 VALUES(6);
COMMIT;

SELECT empid FROM question36
UNION
SELECT empid FROM quest36;

DELETE FROM question36;
DELETE FROM quest36;
COMMIT;

MINUS:- it returns table A values not available in table B.
Example:-
A={1,2,3,4}
B= {2,3,5}
A-B={1,4}

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(5);
COMMIT;

SELECT empid FROM question36
MINUS
SELECT empid FROM quest36;

DROP TABLE question36;
DROP TABLE quest36;

Is This Answer Correct ?    0 Yes 0 No

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between..

Answer / 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

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between..

Answer / ramya p

You could also use this query:

select * from <table_name>
where mod(column,2)=0;

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

what are string data types? : Sql dba

0 Answers  

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

What is integrity in sql?

0 Answers  

sql query to get zero records from a table having n no of records

8 Answers   CTS,

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,




What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

What is varray in pl sql?

0 Answers  

how to get a list of all tables in a database? : Sql dba

0 Answers  

How do I edit a trigger in sql developer?

0 Answers  

How do you add a column to a table?

0 Answers  

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

what is constraining table?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories