SQL multiple column ordering
Posted By: Anonymous
I am trying to sort by multiple columns in SQL, and in different directions. column1 would be sorted descending, and column2 ascending.
How can I do this?
Solution
ORDER BY column1 DESC, column2
This sorts everything by column1 (descending) first, and then by column2 (ascending, which is the default) whenever the column1 fields for two or more rows are equal.
Answered By: Anonymous
Related Articles
- CSS Float: Floating an image to the left of the text
- SQL query return data from multiple tables
- "Large data" workflows using pandas
- Sort table rows In Bootstrap
- SQLiteDatabase.query method
- Sorting Backbone Collections
- Why is there no SortedList in Java?
- Update rows in one table with data from another…
- Add column to SQL query results
- data.table vs dplyr: can one do something well the…
- How to select the comparison of two columns as one…
- How to reset a vue-infinite-loading element?
- Difference between natural join and inner join
- 3 column layout HTML/CSS
- How to sort a dataFrame in python pandas by two or…
- sorting and paging with gridview asp.net
- How to sort an array in Bash
- What algorithms compute directions from point A to…
- Add unique constraint to combination of two columns
- How can I pass a wct test while rearranging children…
- TypeScript metadata reflection references other…
- How do SO_REUSEADDR and SO_REUSEPORT differ?
- Centering in CSS Grid
- CSS Variable trough Polymer (dynamically loaded) elements
- Change column type in pandas
- How to pass 2D array (matrix) in a function in C?
- MySQL combine two columns into one column
- How to sort an array in descending order in Ruby
- Why is processing a sorted array faster than…
- What is a "cache-friendly" code?
- Setting equal heights for div's with jQuery
- How are iloc and loc different?
- python 3.2 UnicodeEncodeError: 'charmap' codec can't…
- Select * from subquery
- Vuejs - cannot ready property of undefined - (but it…
- CASE WHEN statement for ORDER BY clause
- Self-referencing topological execution order in svelte
- Memcached vs. Redis?
- Perfomance issues with large number of elements in…
- Sorting backbone collections with multiple attributes
- Ember: What is the non controller way to sort an…
- Combine two tables that have no common fields
- Handling NULL values in Hive
- Sort a list of numerical strings in ascending order
- What does the Excel range.Rows property really do?
- What is stability in sorting algorithms and why is…
- Sorting an ArrayList of objects using a custom sorting order
- Spark DataFrame groupBy and sort in the descending…
- How to DROP multiple columns with a single ALTER…
- GridView sorting: SortDirection always Ascending
- In CSS Flexbox, why are there no "justify-items" and…
- How do I sort a dictionary by value?
- Ember sortBy on property:desc is not the same as reverse
- Sortable row groups (+ group child rows) with Aurelia
- Individual click handlers in v-for loop
- How to solve Internal Server Error in Next.Js?
- How can building a heap be O(n) time complexity?
- How to prevent scrolling the whole page?
- How does database indexing work?
- How to find Control in TemplateField of GridView?
- Table sorted date not correct
- Ember data FixtureAdapter hasmany - Cannot call…
- Sorting 1 million 8-decimal-digit numbers with 1 MB of RAM
- Using a value convertor on an ES 6 Map in Aurelia
- ascending/descending in LINQ - can one change the…
- Java Array Sort descending?
- How do I limit the number of rows returned by an…
- How to update google-maps-react direction route?
- Dragstart not getting invoked after reordering the elements
- How to display an unordered list in two columns?
- Hide/Show Column in an HTML Table
- What are the undocumented features and limitations…
- Ember.js: Proper way to iterate through object in model?
- Vue element-ui formatter – how to display html?
- SortValueConverter not working correctly when order…
- How to sort by column in descending order in Spark SQL?
- Custom data object with functions in VueJS
- Get first row of dataframe in Python Pandas based on…
- How to make a stable two column layout in HTML/CSS
- How to add multiple columns to pandas dataframe in…
- How to get the in HTML tables to fit content, and…
- Sorting using Comparator- Descending order (User…
- Polymer 1.0 'array-style' path accessors,…
- How to Display Multiple Google Maps per page with API V3
- Web components and JS DOM Elements with a placeholder
- Local variable referenced before assignment?
- Readably print out a python dict() sorted by key
- Column order manipulation using col-lg-push and…
- AG Grid - restore default sort if no other column is sorted
- Rails Active Record find(:all, :order => ) issue
- Why it is hard to use vue-i18n in vue data() (why it…
- vuetify data table pagination custom function
- How to add pagination on vue-tables-2 using Laravel…
- Sort a list alphabetically
- Pandas Merging 101
- An efficient way to transpose a file in Bash
- How can I do an asc and desc sort using underscore.js?
- Check if input field is changed
- correctly implement backbone comparators
- ImportError: No module named dateutil.parser
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
