Questions tagged [sql]

Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used. If your question relates solely to a specific DBMS (uses specific extensions/features), use that DBMS's tag instead. Answers to questions tagged with SQL should use ISO/IEC standard SQL.

Filter by
Sorted by
Tagged with
0votes
1answer
67views
+50

Left Join in Hive Produces Peculiar Results

I have three tables and I want to join them together one by one by some common columns and the end results always have massive amount of null values in them although the data is present (in the second ...
user avatar
0votes
1answer
55views
+50

How to change the column order of an Azure database table in Visual Studio

I've been searching all afternoon for the way to re-order columns of an Azure database table in MS Visual Studio 2022. No luck. In other applications columns are easily re-arranged by dragging or cut &...
user avatar
1vote
4answers
118views
+100

Aggregate multiple tables considering indexing with values derived from one table

Consider I have three tables (bet,win,cancel) that will contain the data for rounds of bets. Each round can have 1 or more bets and 1 or more wins. A round may be cancelled before any wins are ...
user avatar
  • 756