Morshed Chittagong

On 9/19/2019 at 3:02 PM, yrstruly said:

Show your position on the high score board

Show the person in front and below you on the high score board.

What do u mean by YOUR in your post? what you need is not clear on the post. pls elaborate. 

On 8/27/2019 at 6:51 AM, CoolB said:

SELECT * FROM Customers
WHERE NOT Country='Germany' AND NOT Country='USA'and not country="Mexico";

 

I am new to SQL and learning "where not" syntax. Wonder how can I make the above string shorter? or any other way this can be written? how do I use <> here?

SELECT * FROM Customers
WHERE  Country NOT IN ( 'Germany','USA','Mexico');

u can use NOT IN( ) operator.