sql

The need for workarounds like this is the reason I don't like #SQL https://images.d.buzz/file/dbuzzimages/pg-with-distinct.png Posted vi...

... #postgresql Posted via D.Buzz

... snowflake ID types. https://github.com/serpent7776/pg_snowflake Posted via D.Buzz

SELECT * FROM SAMPLE_TABLE FOR JSON PATH The line of SQL code above is what I have been looking for in the last couple of weeks. I alwa...

I have just updated the small help tool “Hive Post Payout Dashboard (using HafSQL)” to a new host endpoint, as the dear @mahdiyari will s...

A View Entity in TypeOrm is like a virtual table that pulls data from your database view. Creating one is simple! Just define a new clas...

... in sql file is next level sql skill. #postgresql Posted via D.Buzz

... and let the optimiser choose the right plan they said. And then you extract part of the big query as a VIEW and suddenly the perform...

GM HiveDevs! In my last post, I introduced the HiveSQL AI Bot, a tool that combines Discord, HiveSQL database querying, and AI capabiliti...

Hey there, HiveDevs! Yesterday I needed to query HiveSQL to get some statistics from PixBee, and I had an idea: why not use AI to create ...

SQL Server, developed by Microsoft, is a relational database management system (RDBMS) that provides a powerful and scalable solution for...

... it mas missing LEFT in a JOIN. ._. #sql Posted via D.Buzz

EN Hello Today I started my SQL lessons, today I understood better how queries are made via SQL. I will try to share what I learned in t...

▶️ Watch on 3Speak This is a new tutorial series on Structured Query Language(SQL), I will start from the basics to advanced concepts li...

The concept of decentralized blacklists and mutes lists was introduced by @blocktrades some time ago. These lists are recorded in the bl...

TLDR; The active HiveSQL proposal will expire at the end of this month. This new proposal aims to continue to provide free access to Hi...

#postgresql query that returns active queries. #sql https://images.d.buzz/sql-active-queries.png.png Posted via D.Buzz

... This means that the primary key will be changed unless you specify it directly. Use INSERT ... ON CONFLICT DO UPDATE to keep the old...

Hi Everyone ❗❗ Especially HiveFest 2024 visitors who are interested in simplified and efficient application development for Hive Platform...

#sqlite has implicit ROWID/OID integer column. #sql https://images.d.buzz/SQLite-Autoincrement.png.png Posted via D.Buzz

... (column)` syntax. #sql #postgresql https://images.d.buzz/sql-distinct-on.png.png Posted via D.Buzz

Converting json to columns in #postgresql #sql https://images.d.buzz/sql-jsonb-to-record.png.png Posted via D.Buzz

List size of #postgresql tables and their indices order by the latter. #sql https://images.d.buzz/pg-sql-table-sizes.png.png Posted via ...

This one does not spark joy. #ocaml #sql https://images.d.buzz/sql-exec.png.png Posted via D.Buzz

INTRODUCTION My name is Chaitanya Sharma and I, along with my hackmates, Introducing the Eco Guardian Battery, the next generation of e...

Composite Primary Key 用两个column作为primary key foreign key is the column used to connect 2 tables in order to create cross referencing betw...

Relation = A relation represents a file that stores data. It’s also known as a table. Domain = The domain is a set of acceptable values t...

Create table cart_order( order_id INT, customer_id INT, product_id INT, quantity INT, order_date DATE, status VARCHAR(100), PRIMARY KEY (...

Select * From student_tbl (table name) Where faculty LIKE 'Sc%' ; within the faculty column that start with Sc followed by any number of ...

DML and DDL are both subsets of SQL (Structured Query Language) used for database management, but they serve different purposes: DDL (...