```
LocationID  LocationName
50          Sharjah
51          Qatar
55          Rigga
6           Dubai Mall

```

I need to make sql query that takes `locationId` as parameter,
if `locationId` is passed 0 then I want to show all this records otherwise show as per `locationId` passed.
I tried case statement but not succeeded.