Lab Sql

I'm trying to read a CSV file from within a web application (Tomcat 5.5.x) and all I get is … Read more How To Access Csv File Within War Using H2's Csvread() Function/query?

How do I adapt the query below so that it doesn't perform unnecessary UNION ALL unless the SELE… Read more Abort Subsequent Union All Commands If Match Found [h2]

This is my table: CREATE TABLE IF NOT EXISTS NODE ( UUID VARCHAR NOT NULL, PARENT_UUID VA… Read more How To Sort Parents And All Siblings Using Cte For Adjacency List?

I am trying to use the sqlFile command of liquibase in my changelog. I have the following in my ya… Read more Liquibase's Sqlfile Command Being Ignored For Sql Server

I have also added another TMP2 and was not able to run the query... Could you please help me on thi… Read more Syntax Error In Sql Statement “with” Keyword Throwing Exception

I'm using JDBC, need to constantly check the database against changing values. What I have curr… Read more Infinite Loop Database Check

I am trying to build an SQL schema for a system where we have channels, each with an id, and one or… Read more Sql One-to-many

SQL Server 2008 apparently has filtered indices. What is the cleanest way to achieve the same in H2… Read more H2 Database: Unique Constraint Only Over Non-null Values? (filtered Index)