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 differences among rownum, rank and dense_rank? : Sql dba

1085

What are the different operators available in sql?

1057

What does select count (*) mean in sql?

1073

What are sql triggers used for?

1035

Can triggers stop a dml statement from executing on a table?

1157

Explain what is sql*plus?

1196

Why do we use joins?

1097

how to calculate expressions with sql statements? : Sql dba

1094

What is sql key?

1043

How to rename a column in the output of sql query?

1124

Is sql a microsoft product?

995

What is form and report?

1051

What does joining a thread mean?

1074

What kind of join is join?

1009

Is sql considered coding?

1088