Author Topic: What?? Really??? (Read 1524 times) Tweet Share

k31453 · « **on:** November 10, 2012, 05:37:45 pm »

I know what is the answer but how do they got it??

Lasercookie · « **Reply #1 on:** November 10, 2012, 05:46:18 pm »

Category <> Decorative, Sales > 14000

I'm assuming the , means AND. I might have just forgotten something, but having the comma there is a bit dodgy imo, they really should have been explicit if they wanted AND or if they wanted OR.

So: Category NOT Decorative AND Sales > 14000

You can cross off anything that doesn't fit that criteria.

It would return the rows with the first Gardenia and the Supercem.

Yendall · « **Reply #2 on:** November 10, 2012, 06:59:33 pm »

Also look at it as "if one thing goes, the rest go too"

So, like laseredd said: Category <> Decorative, Sales > 14000

Gardenia: <> Decorative, >14000 = 20000 $\therefore = returned$
Lime: = Decorative $\therefore = rejected$
Lavendor: = Decorative $\therefore = rejected$
Teak: = < 14000 (12500) $\therefore = rejected$
Supercem: <>Decorative, >14000 = 14500 $\therefore = returned$
Gardenia: <14000 = 12000 $\therefore = rejected$
Lime: = Decorative $\therefore = rejected$
Lavendor: = Decorative $\therefore = rejected$

saifh · « **Reply #3 on:** November 10, 2012, 07:34:01 pm »

The "<>" means it can't be.

Yendall · « **Reply #4 on:** November 10, 2012, 07:48:26 pm »

Quote from: saifh on November 10, 2012, 07:34:01 pm

The "<>" means it can't be.

More technical terms for future use:

>: Larger than
<: Less than
=: Equals
<>: Does not equal

Search the forums now!

We have moved!

Author Topic: What?? Really??? (Read 1524 times) Tweet Share

k31453

What?? Really???

Lasercookie

Re: What?? Really???

Yendall

Re: What?? Really???

saifh

Re: What?? Really???

Yendall

Re: What?? Really???

Recent Posts

User:
Password: