Advertisements I have the following query: SELECT el.event_title ,se.event_eventDateAndTime FROM events__events_list el JOIN events__sub_events se ON el.UID = se.event_masterEvent WHERE (se.event_eventDateAndTime BETWEEN CURDATE() AND (CURDATE() + INTERVAL 45 DAY)) ORDER BY se.event_eventDateAndTime ASC; This produces a list of events ordered by the date: event_title event_eventDateAndTime Event 2 2023-02-22 19:30:00 Event 1 2023-02-23 19:30:00 Event 2… Read More Order by the same column twice

Advertisements What is wrong with my query ? SELECT * FROM table1 JOIN table2 ON table2.table1_id = table1.id WHERE table_2.table3_id = 1 ORDER BY table2.id ASC It does what I want except it doesn’t consider my ORDER BY and apparently keeps ordering by table1.id ASC by default instead of table2.id ASC. It’s like my ORDER… Read More SQL JOIN and ORDER BY

Advertisements I want to browse through all values of two columns in a table: if the value in column 1 is not null, select it, otherwise select the value in column 2 instead. then sort the final result in alphabetical ascending order, wherever column its values came from. I tried the following query but it… Read More Order by first non-null result that comes from two different columns

Advertisements I have a table like this (unsorted): risk category Low A Medium B High C Medium A Low B High A Low C Low E Low D High B I need to sort rows by category, but first based on the value of risk. The desired result should look like this (sorted): risk category… Read More Sort by the "rank" of column values

Advertisements I’m currently trying to list OrderRevenue descending, but it lists the values descending improperly when I test my query. What I’ve tried using: SELECT o.OrderID, DATEPART(YEAR,o.OrderDate) AS OrderYear, DATEPART(QUARTER,o.OrderDate) AS OrderQuarter, E.FirstName + ‘ ‘ + E.LastName AS EmployeeName, C.CustomerName, S.ShipperName, SUM(d.Quantity) AS OrderItems, FORMAT(SUM(d.Quantity*p.Price), ‘C’) AS OrderRevenue FROM Orders o INNER JOIN Employees… Read More FORMAT(SUM(Value*Value), 'C') does not allow me to order by DESC properly

Advertisements My table: id label 1 art2 2 art1 3 art4 4 art3 Expected Output: id label order 1 art2 2 2 art1 1 3 art4 4 4 art3 3 So, I want to set the "order" field with result of SELECT * FROM table ORDER BY label ASC; Is it possible with a single… Read More is it possible to set a `order` field with the result of ORDER BY

Advertisements Description I have three tables. STUDENTS ID Name 1 AAA 2 BBB 3 CCC 4 DDD Skills ID Name 1 JS 2 C# 3 Angular 4 React 5 jQuery 6 TS 7 F# StudentSkill ID StudentID SkillID 1 1 1 2 1 2 3 2 1 4 2 2 5 2 4 6 3… Read More How can I achieve the Ordering result as I mentioned below in C# Entityframe-work?

Advertisements Using latest versions of Postgres, Node and node pg. Trying to figure out why ORDER BY col DESC LIMIT 100 always returns the first rows regardless of order. Here’s the table: CREATE TABLE transactions ( id BIGSERIAL NOT NULL, timestamp timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, user_id INT NOT NULL, to_id INT… Read More ORDER BY id DESC LIMIT 100 returns first rows instead of last

Advertisements I have some data from excel exported to a MySql server. I want to do a query with results sorted with column names as in excel. I had this query statement: SELECT CellValue, Col, Row FROM cell WHERE Col != "A" ORDER BY Col ASC; But the result is order in a way, not… Read More SQL order by column name

Advertisements I created three tables in Database using Entity Framework class User{ public string Name {get;set;} public IEnumerable<Pet> Pets {get;set;} } class Pet{ public string Name {get;set;} public IEnumerable<Toy> Toys {get;set;} } class Toy{ public string Name {get;set;} } I want to select top 10 users (using linq) which have the biggest amount of toys.… Read More EntityFramework. order by count of sub array elements