2

I have a question that seems to be 'simple' solution .. but is still pounding me on the head here, I have a table with the rows

columns: x, y   
1 , 3 
3 , 8 
1 , 2 
3 , 7

then, sometimes, the ordering will be right, knowing that 'all the results in column X' are different, just that .. it is the same, I want to use the column Y as sort criteria, it is possible?

Improve this question

7 Answers 7

Reset to default
6 
select x, y
from [your table]
order by x, y

This is defaulting in ascending order. You can specify 

....
order by x, y desc

To order y in descending order.

The lesson here is that you sort by multiple fields in a table, you just need to separate the column names by a comma in your query.

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

Comments

4

Why not just do:

SELECT x, y
FROM table
ORDER BY x, y;

That sorts by x first, using y as the tie-breaker.

Improve this answer

Comments

3

You can use order by to specify several fields separated with comma (,).

select x, y from table
order by x, y
Improve this answer

Comments

3 
SELECT x, y FROM table_name ORDER BY x, y

This will order by X and then by Y (if X is the same for two rows)

Improve this answer

Comments

2

You haven't posted the query you're using. Are you using 'ORDER BY' at all?

SELECT x,y FROM coordinates ORDER BY x,y;

This would sort first by X then by Y values.

Improve this answer

Comments

1 
select * from <tablename>
 order by x, y
Improve this answer

Comments

0

This would sort the rows by values in col y (ascending):

SELECT x, y FROM table order by y
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.