python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - sql-order-by

SQLite - calculate percentage increase in values of a numeric column

I am interested in getting the % increase or decrease of the values in one column with respect to the previous value. Can someone please advice how I should do this? Thanks This is what my table looks...
test-img

Benjamin Lopez

sql

sqlite

sql-order-by

window-functions

Votes: 0

Answers: 2

Latest Answer

Use LAG() window function to get the previous value of sales for each week: SELECT *, ROUND(100.0 * (1.0 * sales / LAG(sales) OVER (ORDER BY week) - 1), 1) growth FROM tablename ORDER BY week D...
test-img

forpas

Rails is breaking SQL query when modifying order

Context We have a Rails app that is retrieving conversations with the following raw SQL query: SELECT sub.*, profiles.status AS interlocutor_status FROM ( SELECT DISTINCT ON (conversations.id...
test-img

lkartono

ruby-on-rails

activerecord

sql-order-by

Votes: 0

Answers: 1

Latest Answer

Finally found a way to make it work using preload instead of includes. We wanted to avoid having seperate queries to load posts and categories but since performance is not affected by it, we don't min...
test-img

lkartono

SQL - Ordering table with subquery for select

I am trying to do ordering on query with subquery for a name from uuid. Let's have those two tables in MySQL: bans: id uuid time reason 1 c6b8eade-7db9-345b-b838-8f8361552cf5 1642369382 Test ...
test-img

Baterka

mysql

sql

subquery

sql-order-by

Votes: 0

Answers: 2

Latest Answer

That is a JOIN query if I ever saw one. You cannot pass a table or column name as a parameter in either PDO or MYSQLI. The database cannot compile and optimise code with unknown columns or tables in i...
test-img

RiggsFolly

select the most recent item from mysql

i need to select. the most recent item from mysql table. I found several suggestions but nobody was the right one for my case. Just to recap i have a table with id, itemnr, date_edited I tried with: s...
test-img

marco77sa

mysql

sql-order-by

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs