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

Can we write dml inside a function in sql server?

687

what are date and time intervals? : Sql dba

779

what is heap table? : Sql dba

817

Why trigger is used in sql?

699

How do I truncate a sql log file?

763

What is an implicit commit?

770

what is a control file ? : Sql dba

769

What is a loop in sql?

756

What are expressions?

764

What is delimiter sql?

724

What do you mean by stored procedures? How do we use it?

728

Which is better trigger or stored procedure?

704

What is interval partition?

745

What are sql injection vulnerabilities?

703

What is pl sql architecture?

708