I have this stored procedure that selects the top 10 results from its inner join CREATE PROCEDURE SP_SELECT_DOCS_WHERE_JOBID_STATUS @JobID INT, @BatchID
I have a table that gives me data every month and I need that range of time. I noticed that sometimes I don't have data for 3/4 month but I need to duplicate th
I have a staging table which contains all varchar columns. I want to validate a date stored in the data column. Since my staging table contains all varchar colu
I have a table that gives me data every month and I need that range of time. I noticed that sometimes I don't have data for 3/4 month but I need to duplicate th
I use followng code in VB.Net to search data in listview using TextBox. This code was VB.NET i have changed this to C# according to my understanding as i am new
I am trying to create table in spark sql by providing the schema and giving the location. However when i run select on the table, i see only half the columns. (
The following query sorts a binary column in BigQuery: with tbl as ( select B'123' as col union all select B'234' ) select * from tbl order by col; ----------
I need to write a sql code to pull the single, highest-earning day for a certain brand of each quarter of 2018. I have the following but it does not pull a sing
select case when code = number_1 then number_1=code when count(code)>=count(number_1) then number_1 = sum(code)
I'm currently using this query to insert or update my array of data when retrieving my list : try { const query = `INSERT INTO "Tables" ("id","tomerge
I have a Table with Debit Accounts, Credit Accounts and Amount of Transactions between them. I need to take every Account(Which might be debit sometimes and cre
I get the error: 'duplicate key value violates unique constraint' even when checking if the primary key is already in the table in which I want to insert. I ha
I am new to PostgreSQL and am struggling with the creation of a procedure to save the data in a new table. This is how the empty table is created CREATE TABLE e
Posting here in case it helps someone. TLDR: ${database.defaultSchemaName} within sqlCheck to access default schema name I wanted my database changeset to firs
I'm running below code and getting below results but I want to remove ,, and after ,, texts from email address and that email address should show in UPPER(PT_PA
I have a PostgreSQL table where there is column which has array of strings. The row have some unique array strings or some have duplicate strings also. I want t
So I do have following SQL select SELECT FOO.*, ROW_NUMBER() OVER (ORDER BY KEY ASC) AS ROW_NUMBER FROM FOO Key is of the type VARCHAR(12). I wonder why the h
I'm working on a project that uses voice assistant to query information stored in my sql database but I keep getting this error. The voice assistant is able to
I have table which has productId and productVariantId columns. |id |userId|productId|productVariantId| ---------------------------------------- |1 |1
First time posting here, normally I am able to find an answer to my questions by searching but not this time... I have a table T1 with 2 sets of coordinates (st