You could also use this query: select * from <table

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 / ramya p

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

Please Help Members By Posting Answers For Below Questions

What are the advantages of pl sql?

1070

How to return multiple rows from the stored procedure?

912

What is a constraint? Tell me about its various levels.

1082

When is a declare statement required?

1081

What is embedded sql in db2?

956

Does sql use python?

973

What is procedure explain with program?

949

What is view explain with example?

882

what is a constraint? : Sql dba

1105

Explain the difference in execution of triggers and stored procedures?

966

What is trigger price?

925

Can we use ddl statements in stored procedure sql server?

965

How can you load multi line records? : aql loader

1019

What is the meaning of disabling a trigger?

1110

define data blocks ? : Sql dba

930