Only Coders

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 - sql

How to get cerain count of rows near specific row using PostgreSQL?

This is my test data: id | name --------- 1 | aaa 2 | bbb 3 | ccc 4 | ddd 5 | eee 6 | fff 7 | ggg And I need to get constant count of rows (N) in my result (sorting is always by id), when rows...

ThatsMe

sql

postgresql

Votes: 0

Answers: 1

Latest Answer

Nice little problem. You can do: with p (name) as (select 'bbb'), m as (select t.* from t cross join p where t.name = p.name), b as ( select t.* from t cross join p where t.name < p.name order by...

The Impaler

MySQL - creating a query

I need some help, I want to create a query and is difficult for me, how can I create a query to sort table A by value and if the values are equal to check in table B by which value are higher between ...

Andrei

mysql

sql

Votes: 0

Answers: 0

How to deal with repeating player names SQL

I am working with a dataset from Basketball-Reference.com. I have collected statistics from a single season. However, players get traded throughout the season so I have players who have 2 or 3 rows in...

Claire Gehlhausen

sql

google-bigquery

Votes: 0

Answers: 1

Latest Answer

In SQL, whenever we do some aggregations, it is important to group by something. Consider an example of counting average temperature for each US state for entire year. Each state consists of multiple ...

Regressor

In SQL How to choose two of three or more tables to join based on a condition?

I have a total of say 3 tables, but I am only interested in joining two of them based on a condition. There is a lot of Q&A on how to use Case Statements, but that's when tables are already define...

TarrotCarder

sql

sql-server

sql-server-2016

Votes: 0

Answers: 4

Latest Answer

You can left join all three and then select the non-null one using COALESCE(). For example: select p.*, coalesce(a.someinfo, b.someinfo, c.someinfo) as info from price p left join tablea a on a.pr...

The Impaler

Posts

Questions

Blogs

Jobs