Plz help in th query

1

please help in the query from table

SQl
SQl.png768×614 10.7 KB

expected result
Projectname sales RowOrder
MPP_A3501 26.00 0
FSO - Jaswinder 10.00 1
|Z-Practice-TM1-N006 16.00 1
SHELL_Projec-Avneet 167.00 0
Z-Practice-TM1-N006 119.00 1
Z-Practice-TM2 32.00 1
Z-Practice-TM5 16.00 1
TKH PPM V1 21.50 0
Z-Practice-v1 21.50 1

2

select ProjectName, sales, RowOrder from table

1 Like