Consider the Sample table
Query:
Ms-Sql:
select top 1 number from Sample order by abs(number-3.7) ,number desc
My-Sql:
select number from Sample order by abs(number-3.7) ,number desc limit 1
Showing posts with label select int using float. Show all posts
Showing posts with label select int using float. Show all posts
Thursday, July 2, 2009
Select the Nearest Integer value by passing Float
Consider the Sample table
Query:
Ms-Sql:
select top 1 number from Sample order by abs(number-3.7) ,number desc
My-Sql:
select number from Sample order by abs(number-3.7) ,number desc limit 1
Subscribe to:
Posts (Atom)
