Category "sorting"

mysql order by collation

I want to sort the results of MySQL based on the best match by using collate query => zeķ want to show Vīriešu zeķes Sieviešu

How to Sort a Model Based on a Property in IList<T> within that Model

This is a bit more complex than other questions. I have a Model that encapsulates an IList. Within each IList item there are multiple Lists. This makes it VERY

group items accourding to invoice ID

I need to prepare invoice lists and in the each invoice there are more items added by user while shopping here my model public partial class tblNormalSatisBekle

Error 1004 keeps popping out when trying to execute the sort VBA command

Part 1: Please help to advise where did it went wrong. Would like to sort for column E via descending order with header Sub SortRows() Dim destSht As Worksheet

QGIS how to permanently change the order of records? (Sort records/features permanently and output a new shapefile)

Hello I was wondering if somebody knows a way to sort a table from a layer and then, save the new ordered or export this to a new layer with its table ordered b

How to not remove but only print multiply rows from CSV file using a awk?

i have the following code awk -F, '{key=$1 FS $2 FS $3} NR==FNR{a[key]; next} !(key in a)' dubl.txt original.txt which checking for duplicates in multiply colu

Find sorting algorithm for an elevators floor travel schedule, starting from the current floor with preselected floors to reach and a travel direction

I'm making an elevator in react, But I need to make a function that sorts an array to the nearest to the number X and also there is a condition if the elevator

How to sort array of objects by dates and make new arrays which will contain all objects with same date [closed]

I have a very specific problem in Javascript. I have array of objects, and each object contains some date. const array = [ {name: 'first', dat

How to sort array in constant time in java and python?

I was trying to learn algos and data structures, and i was wondering about best approach to sort arrays in constant time. I am newbie but my only intention is t

How to sort entity model by column name of display model in C# .NET Core using LINQ?

I have a page that displays all users in the table. The front end uses a class that is different from the database model. public class UserDetailsViewDto {

Sort object keys/entries in specific order

I have an object like this: const data = { val5: 1231, val3: 1232, val1: 1233, val2: 1234, val4: 1235, }; And its has to be sorted by it keys but in

JavaScript sorting of an RGB array

This is the task: Colors have to be ordered in such way: Higher Red value first; if the same then: Higher Green value first; if the same then: Higher Blue val

How do I sort a material table with favorites on top?

I wanted to sort a mat-table (or MatTable for the search engine) in Angular with the "favorite" items on top. I want the favorite items to always be the first i

Reverse EBCDIC sorts numbers before letters in ROW_NUMBER function

So I do have following SQL select SELECT FOO.*, ROW_NUMBER() OVER (ORDER BY KEY ASC) AS ROW_NUMBER FROM FOO Key is of the type VARCHAR(12). I wonder why the h

Why is Merge sort better for large arrays and Quick sort for small ones?

The only reason I see for using merge sort over quick sort is if the list was already (or mostly) sorted. Merge sort requires more space as it creates an extra

regex - Filter out year from a date string in an array of objects

I'm trying to filter out year out of this array of objects (in React) 2021-12-20, 2021-12-21, 2021-12-22, (...) 2022-01-28, 2022-01-31, 2022-02-01, It has 100

Minimum moves to transform a list so that each element equals its own frequency

Given a sorted array like [1,2,4,4,4]. Each element in the array should occur exactly same number of times as element. For Example 1 should occur 1 time, 2 shou

Best way to sort BOTH prefix and suffix with custom sorting

So I have a list of codes, something like: (I.-) (I.+) (I.0) (B.+) (B.0) (B.-) ... (No value) (N/A) I was able to sort them but we have a "custom requirement" t

Sort array of objects by string property value

I have an array of JavaScript objects: var objs = [ { first_nom: 'Lazslo', last_nom: 'Jamf' }, { first_nom: 'Pig', last_nom: 'Bodine' },

Elastic search script sort text as Number

I have an Elastic search field ID which is a Number but set in the index as a "text". I cannot change the index because of the huge volume of data to reload. I