sorting lists in SQL

Question

I am currently working on an SQL project and am unsure on what code to use in in order to get a specific output. Here is what the output should be " Sort the output in alphabetical borrower name order and then by loan date with the most recent listed first." Is anybody able to give me ideas for this? All I need is what type of code would work, and possibly how to use it?

What all have you tried? Any half-decent SQL tutorial or book will enable you to answer this — Yuvraj Jaiswal, Mar 22 '18 at 14:26
I've tried "Order by" "Desc" and "ASC." One example ive tried is "order by "tablename" DESC" — HankySpanky, Mar 22 '18 at 14:29

score 0 · Answer 1 · answered Mar 22 '18 at 14:27

0

This looks like an 'order by' question. At the end of your query put '....order by name, loandate desc'

answered Mar 22 '18 at 14:27

Daniel Marcus

2,686
1
7
13

would this be after a where clause? or from clause? – HankySpanky Mar 22 '18 at 14:37
Yes after the where clause at the very end – Daniel Marcus Mar 22 '18 at 14:40

sorting lists in SQL

1 Answers1