Can we just fetch all the records where the name GHI should display first
Example :
-----------------
ID | PARTY | NAME
-----------------
1 | CUST | GHI
2 | IND | GHI
2 | IND | DEF
3 | IND | ABC
4 | CUST | JKL
5 | IND | MNO
-----------------