Quote:
Originally Posted by Jessica  Hi,
I have a table consisting five columns Card No, Sdate, Edate, ATime, Etime
Now i want to get three columns info CardNo, Sdate, Edate from table. But i am facing problem when i get input from user to get their required info. For example user want to exact CRad name & his info from a specific Sdate to Edate.
Any effort will be appreciated . |
Following might help.. If SDate and EDate are date type columns..
SELECT CardNo, SDate, EDate FROM table WHERE SDate > INPUT_DATE AND EDate < INPUT_DATE
Alternately better method is..
SELECT CardNo, SDate, EDate FROM table WHERE INPUT_DATE BETWEEN SDate AND EDate