Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in sql

How to write a SQL-Query for the following table?

sql

A nice way to add unique constraint to existing table for Oracles DB?

sql oracle-database

SQL query with calculated dynamic min max

mysql sql oracle-database hive

Ranking - Select corresponding column values to a MAX(column) value

mysql sql

Get row values only if a particular column's value does not exist

mysql sql row

MSSQL - Running sum with reset after gap

sql sql-server

Set a variable inside case statement in mysql

mysql sql database

In Oracle 18c, why is max() much less efficient than order by with fetch first 1 rows only?

Insert CSV file to already existing table within SQL Server

sql sql-server

How to split the data from a single row into multiple rows in SQL Server?

Is it possible to disable `sql_require_primary_key` per database?

TSql Case within Case

MySQL: How to find leaves in specific node

mysql sql sql-optimization

How to get previous month from 'yyyy-MM' date format in Hive

sql date hive hiveql

I can't Convert SQL Select Query Result to Bit

Aggregation over STRUCT in BQ

sql google-bigquery