If i select city,name from table people , so can i use order by state ?

Answer 1

Definitely you can, given you have a column of state in your table people

Answer 2

ok , so its not mandatory that order by should contain a same column that i have selected ?

Answer 3

No that's not necessary

Answer 4

thank you Puneet