i want to extract a value from a json column. The schema is (- first level, -- second level): Column Name | Type | Mode event_params RECORD NULLABLE -key STRI
We are trying out the REMOTE functions within bigquery as per this guide. We created the CLOUD_RESOURCE using the following command : bq mk --connection --disp
I'm new to SPARK-SQL. Is there an equivalent to "CASE WHEN 'CONDITION' THEN 0 ELSE 1 END" in SPARK SQL ? select case when 1=1 then 1 else 0 end from table Tha
I have a table with Document Numbers and items. We have integrated our software to a third party accounting package. The import to the third party does not take
I have a column in a table that I want to use for an unique-index. My script should make the data unique by concat the id of a record, if the data of current re
Here's my table like below p_no type name value ------------------------ 1 A Tomy 1 1 A Nick 2 1 B Tomy 3 1 B Nick 4 1
Imagine there is a table with 1000 columns. I want to add a row with values for 20 columns and assume NULLs for the rest. INSERT VALUES syntax can be used for t
Table Name: Worker, Fields : worker_id | first_name | last_name | department I have a table name worker and i wanted to write an SQL query that fetches the uni
I have a data set like this. CREATE TABLE EntityItems ( Id INT NOT NULL, EnitityItemId INT NOT NULL, PRIMARY KEY (Id, EnitityItemId) ); INSERT INTO
When it comes to database replication, what is the use of global transaction identifiers? Why do we need it to prevent concurrency across the servers? How is th
I'm trying to solve the Hackerrank problem Weather Observation Station 3 which is stated below: I came up with the following solution: SELECT CITY FROM STAT
I want to merge multiple record into single record Ex: Input pdt status start_dt end_dt a Inactive 2022/02/02 2022/02/04 a Inctive 2022/02/05 2022/02/10 a Acti
I have following incrementing id: create table PATIENT ( PATIENTID INTEGER generated by default on null as identity ( start wit
Query: Query the 2 cities contained in STATION table with the shortest and longest CITY names, as well as their respective lengths (i.e.: numb
This is what I am trying to do: SELECT id, name FROM users WHERE isActive=true (AND CASE WHEN {param} != null THEN name={param} ELSE null E
How to update record many columns with the same data of existing record in the same table . For Example : id name m_value 1 moh 1000 2 jo 0
I'm getting this error from SQL Server on SSMS 17 while running a giant query: Conversion failed when converting the ****** value '******' to data type ****
Does anybody know what is the limit for the number of values one can have in a list of expressions (to test for a match) for the IN clause?
I'm new to postgresql. Can anyone suggest the reason and solution to this error? However it works if I select an extra sum(s.length) but i don't won't this in m
I'm working in a centralized monitoring system on Windows 2008 R2, I have installed a PostgreSQL 9.3 to use psql from the command line. When I try to access to