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 is clause in sql?

584

How can we find duplicate records in a table?

514

Why we use sql profiler?

562

Explain what is a database?

651

How do you create an update query?

524

What is a record in a database?

559

What is cross join example?

555

How much does a sql dba make? : SQL DBA

509

Is id a reserved word in sql?

661

What is the difference between inner join and left join?

547

How do I find duplicates in sql?

507

What is the difference between clustered and non-clustered index in sql?

523

explain the advantages and disadvantages of stored procedure? : Sql dba

532

What is foreign key and example?

516

Why stored procedure is faster than query?

519