SQL Between

[Socheat Net]

Dear All, I Use Oracle DB I would like to ask you that I have one table that has records from 010000000 until 010999999 I want select query only start from 010203000 until 720000 numbers. Please help me

Socheat

[Ashfield]

Just add a where condition to your query.

select ....
from ...
where id >= 720000 and id <= 10203000

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Niladri_Biswas]

I am presenting two solutions for your problem. 1) What Ashfield has already presented 2)

SELECT *

FROM tblName

WHERE RECORDNUMBER BETWEEN 010203000 and 720000

ORDER BY RECORDNUMBER ASC

Hope this helps :)

Niladri Biswas