got the ans..
just a silly mistake of extra space..
thank u..
Ashish Pandey
Last Activity: Feb 13 '12, 01:44 PM
Joined: Feb 13 '12
Location:
-
select count(*) from table_name not showing desired result
hello..
i have a simple table ATTENDANCE with following columns and value..
create table ATTENDANCE
(EMP_ID VARCHAR(20),
STATUS VARCHAR(10),
DATE DATETIME);
EMP_ID STATUS DATE
A1 PRESENT 2012-02-13 00:00:00.000
A2 PRESENT 2012-02-13 00:00:00.000
now my problem is when i m firing the query as:
select count(*) from ATTENDANCE where emp_id='A1' AND STATUS='PRESENT ';...
No activity results to display
Leave a comment: