Spark Sql Blog

I am trying to iterate an dynamic array as input for select query. The select query is not firing f… Read more Issue With Loop The Select Query In Sqlite?

I have a job setup that currently selects records from a table that does not contain a unique inde… Read more Sql Select 3 Columns And Dedupe On Two Columns

Consider the following table: ticker code -------------- AA 151040 AAP 452020 DOW 151… Read more Select Distinct Only First Four Numbers

Is it possible to have a foreign key that requires either column A or column B to have a value, but… Read more Foreign Key For Either-or Column?

I have a table called player_chest, which has the following fields: idx integer NOT NULL, player_id… Read more Get First Available Index In The Table, Including 0

I recently saw the new feature announced on Google I/O Room Persistence Library to work with Sqlite… Read more How To Import Room Persistence Library To An Android Project

I have a question about sql. I use jDeveloper and oracle sql developer. I wanna make search case in… Read more Oracle Sql Collation

I started getting this problem recently. Don't know how it started but I know I disabled some w… Read more "class Not Registered" Error When Opening Recordset Using Vb6

I am trying to create a stored procedure using pass-through query in SQL Server 2012, using MS Acce… Read more Access-sql Pass-through Query (creating Sp) Error

I have the following table with values as CREATE TABLE stud ( sname NVARCHAR(10), hr… Read more Sql Pivot Table With Three Cross Tab And Multiple Columns Dynamically

I currently have a query that reads from a table which is written to daily, so I have totals for ev… Read more Using Days Of The Week For Aggregates In Db2

The following simple query takes a very long time (several minutes) to execute. I have an index: c… Read more How To Structure An Index For Group By In Sql Server

I know it's not a code question. However, i try to work on some databases that stored in direct… Read more What Are Com.sec.android.provider.* Apps Exactly?

Is there a way to merge two rows of data and save into another table in SQL Server? Example, I have… Read more Sql Server: Merge Two Rows Of Data From Same Table And Save Into Another Table

i have a table that contains: itemid inventdimid datephysical transrefid 10001 123 2015-0… Read more Sql Group By And Max And Other Values

I need to display a list of dates, which I have in a table SELECT mydate AS MyDate, 1 AS DateType F… Read more Sql To Get List Of Dates As Well As Days Before And After Without Duplicates

I am currently working on a system that has 2 tables set up like so: Table_1 ------- ID Table2ID Va… Read more Pivot Rows To Columns With More Than 1 Value Returned

I have following two queries. The first query is straight forward and is working as epecte when @My… Read more Case Is Not Working Properly

I'm trying to perform the below query, but, I'm getting the error: Msg 457, Level 16, State… Read more Issues With Missing Collate In Sql Server

I have this sample data below (table1): PKEY DATE ---- ---- ABC1 2/13 CFG5 1/05 POK9 1/10… Read more How Can I Get The Max Date (per Primarykey) And Get Its Difference With The One From Another Table?

Based on the requirement I need to change logic. I have students table and columns like id and val.… Read more How To Write Query In Mysql For Json Array Objects

When I generate a SQL file out of my changelog file the databasechangelog table is created as a CSV… Read more Liquibase Databasechangelog Table In Updatesql Mode

This question is virtually identical to another I recently asked, with the very important distincti… Read more How Do I Grab The “next” Event When The Offset Is Variable For Items That Can Be Repeatedly Processed?

I have one table: CREATE TABLE cust ( cust_id NOT NULL, cust_name NOT NULL, address NUL… Read more Inserting Null Values When Using Bulk Insert

I have a radgrid with the setup below. I'm able to properly insert a new row into my table but … Read more Automatically Inserting Datetime With Insert

SELECT * FROM Tbl_Vulpith_Registration WHERE MemId NOT IN (select MemId from Tbl_PublicLink); Solut… Read more Need Equivalent Linq Query For My Sql Query

I have an android application that has 2 tables, one table stores posts and the other table stores … Read more Getting Data From Multiple Tables Sqlite

I am using T-SQL I have a few excel files located here: C:\MyFiles\ I want to remove all the apostr… Read more Rename Files On Disk With T-sql

I have a table X where a trigger will insert a row when there's a changes to some tables. I'… Read more Sql Query Select From [value From Column Of Another Table]

I have a use case where I have a word and I need to know the following things: Synonyms for the wo… Read more Wordnet Query To Return Example Sentences

I need to import a csv file (122 GB, all fields are integer or string) to a table on IBM netezza sq… Read more Error Of Importing Data From Csv File To Ibm Netezza Sql Database

I would like to generate the 'hierarchy id' values which is denoted in red. The value is th… Read more Sql Server Hierarchy With Parent Id And Child Id

Searched and searched and gave up. All I want is more info on a MySQL table or better yet, a list o… Read more How To Display All The Tables With More Information (create Date, Size,...) In A Mysql Database?

I have a table called Employees, having 100 records. The columns are ID and Name. 100 is just a sam… Read more Divide The Table Data Randomly Based On Percentages

There is a text field called myDate. This field can contain either 1) 'Fiscal year ending someD… Read more Sql: Extract Date From String

I was with the choice of SQLite as database for easy distribution of my offline c# desktop applicat… Read more Can Mysql Be Installed As An Embedded Database With An Offline Application?

If a user has SELECT, INSERT privileges on the underlying table of a view, would he automatically h… Read more Are The Privileges On Underlying Table Automatically Passed On To Any Views Created On The Table?

My SQL Server 2008 server database for one of my new projects has deleted accidentally. What I'… Read more I Have Lost Sql Server 2008 Database, I Need To The Database Structure Back From Linq Schema

I know this question must have been asked a million times but I have yet to find a 'NON-VBA'… Read more Ms Access Upsert (update/insert) Sql

I was wondering what is the best way to parse a DateTime object to your SQL server. Where you are … Read more Best Way To Parse Datetime To Sql Server

So i have database with a table called users.. and in that table there is a column named IP and i … Read more Search Phpmyadmin Database For Similar Entrys

I have the following table 'Sales' in MS SQL Server, where [FieldX] is not updated properly… Read more Sql Update And Case Statement Does Not Work

So I am trying to make a SQLite database for my Discord.js bot, but I keep getting this error (Cann… Read more Sqlite Discord.js: Cannot Read Property 'run' Of Null

I'm trying to find a query for sql that will just insert values but not do it should the value … Read more Insert Into Ignore Duplicates That Are Not The Primary Key

Hi I am using DB2 sql to fill in some missing data in the following table: Person House F… Read more Fill In A Null Cell With Cell From Previous Record

I need to write a query which allows me to find all locations within a range (Miles) from a provide… Read more Distance Between Two Coordinates, How Can I Simplify This And/or Use A Different Technique?

SQL Server is not my strong point and I start to get lost when going past the basic Create Table, S… Read more Need To Learn How To Set Appropriate Permissions On Sql Server Database To Allow Synchronisation Through Sync Framework 2.1

I have conversations with many messages and I want to order the conversations in order of the creat… Read more Nhibernate - Subselect In Select With Order By