Link to home
Start Free TrialLog in
Avatar of Varshini S
Varshini S

asked on

Need help for SQL query

I have the following table

create table student (Name varchar(50), Attdate datetime )


insert into student values ('aaa','2014-08-01 08:43:12.037');
insert into student  values ('bbb','2014-08-01 08:43:12.037');
insert into student  values ('bbb','2014-08-02 07:43:12.037');
insert into student  values ('aaa','2014-08-02 08:43:12.037');
insert into student  values ('ccc','2014-08-03 11:43:12.037');
insert into student  values ('ddd','2014-08-04 07:43:12.037');
insert into student  values ('aaa','2014-08-04 07:43:12.037');
insert into student values  ('eee','2014-08-04 08:43:12.037');
insert into student  values ('bbb','2014-08-04 07:43:12.037');
insert into student  values ('ccc','2014-08-05 07:43:12.037');
insert into student  values ('qqq','2014-08-05 07:43:12.037');
insert into student  values ('fff','2014-08-05 08:43:12.037');
insert into student  values ('ccc','2014-08-05 16:43:12.037');
insert into student  values ('aaa','2014-08-06 08:43:12.037');
insert into student  values ('zzz','2014-08-06 08:43:12.037');

I need to find who are the odd students and who attended only on Monday.

Result :
Name
ddd
qqq
eee
ASKER CERTIFIED SOLUTION
Avatar of Habib Pourfard
Habib Pourfard
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial