+ 2
how do we sort by using the last three letters of names of people in the people column in a table?
5 Respuestas
+ 2
select * from table order by right(people,3)
+ 1
you could declare it like variable
0
right(people, 3) showing error near "(".
I m using customer table here and tried query - order by right(firstname, 3)
0
hmm.. try this: select * from table as a order by right (a.people,3)
0
Showing the same error. the Right option seems unidentified I guess. Btw, what is the significance of using "a." here?