python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - groupwise-maximum

For how many customers was this the first-ever merchant they ordered with? SQL question

I am struggling with this sql question: For each merchant, find how many orders and first-time orders they had. First-time orders are meant from the perspective of a customer and are the first order t...
test-img

milkeyyy

sql

postgresql

groupwise-maximum

Votes: 0

Answers: 1

Latest Answer

you can try this with cter as (select , dense_rank() over (partition by customer_id order by order_timestamp ) h from doordash_orders) select * from (select merchant_id,count() gb from cter group by m...
test-img

Swayonok kundu

MySQL Select where in array of statuses and last occurrence equals specific value

Let's say I have a table like this: id user_id status updateded_id 1 1 yes 2/5/2013 2 2 no 2/1/2013 3 3 yes 1/28/2013 4 2 yes 1/24/2013 5 2 n...
test-img

matisa

mysql

laravel

inner-join

exists

groupwise-maximum

Votes: 0

Answers: 3

Latest Answer

You could do this. A user has multiple statuses and you want to get the users based on the latest status right? Eloquent user model class User extends Authenticatable { use HasApiTokens, HasFactor...
test-img

sithuaung

How to handle ties in SQL

SELECT employee_id, department_id, first_name, last_name, hire_date, job_id FROM employees e WHERE hire_date IN ( SELECT max(hire_date) FROM employees ...
test-img

PySquirrel

sql

oracle

groupwise-maximum

Votes: 0

Answers: 2

Latest Answer

You can use a not exists query which gives you more flexibility: SELECT * FROM employees e WHERE NOT EXISTS ( -- no x exists that... SELECT * F...
test-img

Salman A

MySQL query for lowest price for majority of prices in table

I'm trying to build a query where by I can extract the lowest price in the table, where the price is at least 10% or more of all the prices in the table. I understand I can use MIN(price) to get the b...
test-img

ACKA

mysql

groupwise-maximum

Votes: 0

Answers: 1

Latest Answer

Here we use rank() over partition by in a cte to number the records of each productID from lowest to highest. We thank take the lowest price where the rank number is higher than one tenth of the numbe...
test-img

user18098820

Posts

Questions

Blogs

Jobs