Our training courses

Other training resources

Our training venues

Why we are different

Details for eric

eric has participated in the following threads:

Added by eric on 05 Nov 2017 at 07:51

1st query should not return 4 rows but 1

select * from tblEvent
where EventDetails like '% train %' and CategoryID != 14

i guess your query is:

EventDetails like '%train%'          

which is incorrect as it will return words such as training...etc

Added by Kareem44 on 07 Sep 2017 at 10:03

cannot solve it

select EventName, EventDetails, EventDate from tblEvent where  (CountryID = 8 or CountryID = 22 or CountryID = 30 or CountryID = 35) or EventDetails = '%water%' or CategoryID = 4 and year(EventDate) >= 1970

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...