Our training courses

Other training resources

Our training venues

Why we are different

if i have array of numbers

10, 9.8, 10.1, 9.5, 10.8, 9.7

I would like to arrange this array by nearest to 10.

To compare this array to 10. I am going to subtract array values from 10:

(10-10), (10 - 9.8), (10-10.1), (10-9.5), (10-10.8), (10-9.7)

0, 0.2, -0.1, 0.5, -0.8, 0.3

To compare numbers i have to consider both postives and negatives, so i am going to use absolute values

0, 0.2, 0.1, 0.5, 0.8, 0.3

Now let's arrange these numbers nearest to 10:

0, 0.1, 0.2, 0.3, 0.5, 0.8

Now write down with corresponding numbers:

10, 10.1, 9.8, 9.7, 9.5, 10.8

So to summarize, i arranged numbers by using ABS(MyNumbers - 10)

## Added by najilevi on 26 Jul 2018 at 09:08

Hi,

I tried to solve exercise B with the WAR and the DEATH but haven't succeeded207 yet.  Can someone can help me and write the correct answer?

This is what I wrote:

select *
from tblEvent
where CategoryID = 5 or CategoryID = 6 and (EventDetails not like ('%war%death%')

Thanks

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE