height in feet+inch
V prasadSep 29 2010 — edited Sep 29 2010hi
i have table and data like below..
CREATE TABLE HEIGHT (FEET NUMBER(2), INCH NUMBER(2), NAME VARCHAR2(6));
INSERT INTO HEIGHT VALUES(3,1,'JOHN');
INSERT INTO HEIGHT VALUES(3,7,'SMITH');
INSERT INTO HEIGHT VALUES(3,0,'MILLER');
INSERT INTO HEIGHT VALUES(5,2,'SCOTT');
INSERT INTO HEIGHT VALUES(5,8,'KING');
INSERT INTO HEIGHT VALUES(6,6,'TIGER');
INSERT INTO HEIGHT VALUES(6,7,'SYS');
INSERT INTO HEIGHT VALUES(6,6,'LUISE');
INSERT INTO HEIGHT VALUES(7,0,'CAT');
INSERT INTO HEIGHT VALUES(7,5,'MAT');
INSERT INTO HEIGHT VALUES(7,9,'RAT');
INSERT INTO HEIGHT VALUES(3,4,'');
SELECT * FROM HEIGHT ORDER BY FEET, INCH
now i want to retrieve date from 5.2 to 7.5.
here 5 is starting feet and 2 is inch
and 7 is sending feet and 5 is inch