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

Define union, minus, union all, intersect ?

1013

Is delete faster than truncate?

1010

how can we optimize or increase the speed of a mysql select query? : Sql dba

956

How to start the command-line sql*plus?

1061

Can we debug stored procedure?

1032

What are the steps for performance tuning.

1346

What is trigger explain it?

1021

what are the disadvantages of mysql? : Sql dba

1151

How many types of triggers exist in pl/sql?

1080

How do you clear the screen in sql?

1082

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1048

define sql insert statement ? : Sql dba

1035

What is the meaning of disabling a trigger?

1187

what is an extent ? : Sql dba

1109

What is composite data type in pl sql?

1123