Getting Started With Azure Cosmos DB for PostgreSQL
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
2024-07-29
786 reads
Shivayan Mukherjee
- Interests: coding, travelling, outdoor games
PostgreSQL UNION, INTERCEPT & EXCEPT Operator
Another article on how the SQL language works in PostgreSQL. This time we examine the UNION, INTERSECT, and EXCEPT operators.
2024-05-31
1,148 reads
Getting Started with DDL statements of Cassandra Query Language
Learn the basics of how to work with objects in Cassandra, a NoSQL database.
2023-12-01
1,182 reads
2023-08-25
494 reads
PostgreSQL Copy
In this article you will learn how to use the COPY command in PostgreSQL to copy a database or a table.
2023-06-09
4,110 reads
PostgreSQL Table Import/Export from and to CSV File
This article will cover exporting data from a PostgreSQL table to a CSV file, both from the command line and pgAdmin. We will also look at importing data from a CSV file.
2023-05-05
1,441 reads
2023-03-17
4,653 reads
2023-02-17 (first published: 2023-02-10)
10,712 reads
Cassandra Springboot Integration
In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.
2022-11-04
2,430 reads
2022-10-14
7,632 reads
Blogs
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Forums
Networking Devices in Ellington, CT | Legacy Technology, Inc
In today’s connected world, a reliable network is the backbone of any successful business....
Cannot install development version.
A while into install I get a Microsoft OLE DB Driver for SQL Server....
More Funny SELECTs
Comments posted to this topic are about the item More Funny SELECTs
Question of the Day
More Funny SELECTs
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers