Using BCP Command for Query Result set Data Export as File

[@Dgprabhu]

Hi Sir ,
I have followed the same and all the records are coming in one column in .csv file . Did I miss any steps ?

[@kalaiyarasiBK]

How to exclude the last row using this command?

[@Casdias]

Good, but how to put the header in result!? 👏