Custom Sort In SQL | Most Important Interview Question |

[@Harishsatya-b4b]

Well explained 👍

[@gauravsaha2544]

Nicely explained .Thank you

[@SachpreetPattnaik]

thank you bro for these type of Q

[@codinglake]

Welcome 😊

[@SachpreetPattnaik]

Bring more Questions please

[@codinglake]

@@SachpreetPattnaik yes i am working on it.

[@nigamsaha6856]

Great 👍

[@devendrabarasker4987]

Try this...
select *,case when Country='india' then 0 else [Happiness Rank] end as Flag from [dbo].[World Happiness Report]
order by case when Country='india' then 0 else [Happiness Rank] end

[@nanisai1532]

select * from HappinessData
where Country="India"
union
select * from HappinessData

[@codinglake]

Nice one.

[@DILLIPAKUMARCHOUDHARY]

BRO INSERT SCRIPT

[@codinglake]

check description.