comprasconencanto1

Way to do in sqlite what is typical in most DB? if exists(select 1 from tosync where tbname = '… Read more Conditional Query In Sqlite

I want to split multiple values from a row into a separate row in sap hana sql. table : id name … Read more How To Split Multiple Values From A Row Into Separate Rows?

Have a Type 2 Dimension residing in an Impala table with ~500M rows having 102 columns : ( C1, C2, … Read more How To Solve A Gap-and-islands Problem With A High Volume Set Of Data In Impala

I have a set of data that is in two different tables. I want to join them up on my /show page in my… Read more Activerecord Find And Only Return Selected Columns Aligned With [:id]

sorry for this newbie question ... im trying to get number of rows per year of my table..... this i… Read more Query To Select Count Of Records For Each Year

I have a problem with SELECT query in ORACLE SQL. There is a table named 'Battles' with col… Read more How Can I Select A Column Named 'date' In Oracle?

I want to make a program that pulls objects from a sql database and processes the objects against a… Read more Process For Pulling Data From A Sql Database

Why does both functions fail me? Or is this just an illusion? Solution 1: You should be using PDO … Read more Escaping Strings For Sqlite3 In Php5

I have a project for one of my classes. We need to create a log when two of our tables have changes… Read more Using A Trigger In Oracle To Log Changes To A Table

I have two distinct mssql databases with identical schemas but different data on one system. I want… Read more Merging Two Databases

I have a stored procedure with 2 parameters. I'm able to execute stored procedures with one par… Read more Stored Procedure Not Fetching Data Even-though The Sqlsrv_query Has No Errors

Microsoft SQL SERVER: I am working on a skills matrix problem. The example below is a simplified sc… Read more Union Nulls Into View That Can Be Queried Later

So I am unfortunate enough to work in an organization who uses SSMS18, meaning I don't have the… Read more Why Aren't My Breakpoints Hitting Sql In Visual Studio 2019 Debugging Script From Network Server

I am using this awesome code from @Richard aka cyberkiwi to run a query (it returns the sum of valu… Read more How To Join A Table To This Sql Code?

I have a Python program that connects to an MSSQL database using an ODBC connection. The Python lib… Read more How To Get Entire Varchar(max) Column With Python Pypyodbc

I'm currently working on a sample script which allows me to calculate the sum of the previous t… Read more Dynamic Row Range When Calculating Moving Sum/average Using Window Functions (sql Server)

I have line segments and points stored in a db. How would I query the db in order to retrieve the a… Read more Query Set Of Points In Area Within Distance From Line Segment

I have a Postgres JSONB field, with some nested arrays and other objects. from sqlalchemy.dialects.… Read more Sqlalchemy Filter Nested Jsonb Within Arrays

Find patients who visited two different doctors of the same specialty in the same day. Example data… Read more How Do I Write A Simple Select Query Instead Of Using Views?

Is it possible to return zero if a value is less than zero without using a case statement? e.g. Max… Read more Return Zero If Value Less Than Zero