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

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

Can sql function call stored procedure?

1025

What is the advantage of index in sql?

972

What is primary key in db?

1011

What is varchar used for?

1082

Can we create a trigger on view?

896

what is a constraint? : Sql dba

1172

What is set serveroutput on in pl sql?

1297

What is meant by cursor in sql?

1000

How do you delete a table?

1075

What are local and global Indexes and where they are useful.

1444

How do I find duplicates in a single column in sql?

1020

What is a subquery in sql?

1040

Is time a data type in sql?

910

What is pl sql record in oracle?

1035