sijayreddy
Last Activity: Dec 13 '07, 12:17 PM
Joined: Dec 10 '07
Location:
-
Thank u mwasif...it is working now...... -
Hi
Hear am giving all the details how i created the table and inserted the data and the query for retrieving the data
[CODE=mysql]
create table ex(name char,mark float,total float);
insert into ex values ('a',10.5,55.5) ;
insert into ex values ('b',1156.66,56 56.65);
select * from ex where mark=10.5;
select * from ex where mark=1156.66 ;[/CODE]
for the first query...Leave a comment:
-
i think this may not be correct ...Why because we are using the round function means we are making that Float value as integer...I don't want to compare two integers i want to compare float values...becaus e in my application even 0.4 value makes a lot difference...pl ease tell me the reason for this and what to do......Leave a comment:
-
How to retrieve float values from data base
Hi all
For ex am having the table student with fields student name and marks...Where as name is of the type string and marks float value....and having the records
Studentname Marks
aaa 10.5
bbb 15.3
Now am writing the query [CODE=mysql]Select * from table where Marks=10.5;[/CODE]
But while executing this query am getting 0 results....What can i do...Is there...
No activity results to display
Leave a comment: