Tag: sql

spark [dataframe].write.option(“mode”,“overwrite”).saveAsTable(“foo”) fails with ‘already exists’ if foo exists

I think I am seeing a bug in spark where mode ‘overwrite’ is not respected, rather an exception is thrown on an attempt to do saveAsTable into a table that already exists (using mode ‘overwrite’). …

Sort by Name first then number in sql query from a delimited string

sorting sql sql-like sql-order-by sql-server-2008

We have designed to register customer’s station-division records in 1 field. So the table rows looks like this. create table test4 (f2 varchar(100)) insert into test4 (f2) values (‘A08-0100’) insert …

Flask SQLAlchemy query join

flask-sqlalchemy python sql sqlalchemy

I have 2 table like this: Then I try to making 2 kinds of query to get data for the relationship models. first, I make it like this: and the second one I use join statement on that: My questions are, what’s the difference in that query while in the second one I use the join statement but the result

How to insert NULL into decimal type column using PHP?

mysqli php sql

I’m trying to insert NULL into a column, called price, which is of type Decimal. The column is nullable and the default is NULL. I want to insert NULL, only when nothing has been entered in the “…

How to extract the package name using regexp_substr

plsql regex sql

I’d like to extract the package name using regexp_substr. For example: create or replace package body something.pkg_test is I want that: pkg_test I tried to use lookbehind just to ignore “…

CASE to sum column based on boolean

case google-bigquery sql

I have: Then I group by to get the counts but how do I sum X when Y is TRUE only? Or get the % of A in relation to true/untrue? Answer how do I sum X when Y is TRUE only?

SQL – Insert rows on missing value with previous row information

sql sql-server

I have queried the tables in a SQL Server database that return a result set with CId (the CId can be in range from 0 to 6) with the quantities. Result: I want to insert the missing CId into result table with previous row CId -> qty, if there is no previous value in group then insert qty as 0