SQL query (Sort by multiple columns)

Question

I have a problem writing a specific query for my database I have a table with the following records:

[ID(PK),Writer,Title,Year,Description]

. I want to sort the records first per year and secondly per Writer for every Starting Letter(A-Z). So Have a result as this

Year     Writer  Title
1999       A1      X
1999       A1      Y
2001       A2      V
2002       A1      Z
1991       B1      P
2002       B2      Q
2003       B1      R

So at the end will be years at ASC form for every Letter of the Alphabet (Writer ASC)!

In your result 1991 comes after 2002. How is this sorted by year? — Mureinik
– Mureinik, Commented Sep 27, 2015 at 17:41
Also other than your try what are the original data to be sorted ? — Abhik Chakraborty
– Abhik Chakraborty, Commented Sep 27, 2015 at 17:41
I want to sort first by year 1991-2002 and then by Name for every Name — androidgame2014
– androidgame2014, Commented Sep 27, 2015 at 17:45

Larz Plutzin · Accepted Answer · 2015-09-27 17:42:43Z

1

SELECT YEAR, WRITER, TITLE ORDER BY YEAR, WRITER;

Something like this will sort by writer within year.

answered Sep 27, 2015 at 17:42

Larz Plutzin

113 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Deepak Sharma Over a year ago

@androidgame2014 okay.. but ur question shows something different.. just opposite.

Larz Plutzin Over a year ago

Right androidgame2014, like @Deepak Sharma said if that's what you meant to write.

Deepak Sharma · Accepted Answer · 2015-09-27 17:47:05Z

0

@Larz Plutzin..

he want the record to be sort first by author then by year. check what he posted..

your query going to be like - may be he could not explain the written what he wants. but the result he wanted going to be like this only..

SELECT YEAR, WRITER, TITLE ORDER BY WRITER, YEAR;

answered Sep 27, 2015 at 17:47

Deepak Sharma

4,1801 gold badge17 silver badges31 bronze badges

Collectives™ on Stack Overflow

SQL query (Sort by multiple columns)

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related