Our training courses

Other training resources

Our training venues

Why we are different

Details for Priyanshu

Priyanshu has participated in the following threads:

Added by Priyanshu on 22 Dec 2019 at 20:36

SELECT EventName, EventDetails, EventDate
FROM tblEvent
WHERE (CategoryID = 4 OR CountryID IN (8,22,30,35) OR EventDetails LIKE '% WATER %')
AND DATEPART(YEAR, EventDate) > 1970;

Added by Priyanshu on 22 Dec 2019 at 20:34

we could use CONCAT function as well:- thanks :)

SELECT CONCAT(EventName,' ', '(', 'category ', CategoryID, ')'), EventDate
FROM tblEvent
WHERE CountryID = 1;

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 ...