bhakti_thakkar
07-28-2008, 08:17 AM
hi all,
i am having a table in which i have a column datatype (decimal) .
Now i want to find all the rows where value in that column is greater than .00 eg if there are 3 rows with values : 50.50 , 11.1 , 12 , 14.01 then query should return me only 50.50 , 11.1 and 14.01.
Thnaks in advance
i am having a table in which i have a column datatype (decimal) .
Now i want to find all the rows where value in that column is greater than .00 eg if there are 3 rows with values : 50.50 , 11.1 , 12 , 14.01 then query should return me only 50.50 , 11.1 and 14.01.
Thnaks in advance