how do we sort by using the last three letters of names of people in the people column in a table?

Answer 1

select * from table order by right(people,3)

Answer 2

you could declare it like variable

Answer 3

right(people, 3) showing error near "(".
I m using customer table here and tried query - order by right(firstname, 3)

Answer 4

hmm.. try this: select * from table as a order by right (a.people,3)

Answer 5

Showing the same error. the Right option seems unidentified I guess. Btw, what is the significance of using "a." here?