Lab Sql

I would like to use a stored procedure to insert some values passed in as parameters into elements … Read more Use Of Xml.modify To Insert Parameters Into Specific Element Of An Xml Column

I have a table, with 3 columns A, B , C - where A is not the primary key. We need to select the B, … Read more Append Results From A Query To The Same Result Row In Postgresql - Redshift

Hi guys Im trying to retrieve some data I inserted into a database in a previous activity. This is … Read more Why Am I Getting A Column Doesnt Exist Error With The Name Of The Table

I'm working on some book exercises and can't find an explanation on how to express the foll… Read more How To List Each Pair Of Tuple Only Once Irrespective Of Column Order In Sql And Relational Algebra?

In the wiki for node-mysql, I noticed that variables (kind of) were inserted into the SQL query in … Read more Inserting Variables Into Sql Query For Node-mysql

I have 3 tables A, B and C. Each table has an ID and a value field. What kind of join do I use to c… Read more What Kind Of Join Do I Need To Use To Create One Table From Many?

I have 3 tables: Create TABLE Subjects ( SubjectID INT PRIMARY KEY NOT NULL IDENTITY(1,1), … Read more Sql Server Perform A Delete On All Child Records When Deleting From A Parent

I have a table that stores a list of records for Maintenance tasks that have been done and the date… Read more Max() In Oracle Sql

I have a big query table which looks like this: event_date event_timestamp event_name … Read more Counting Rows That Had A Previous Event With A Condition In Bigquery

I am stuck with my query. I have a table called Patient. In this table a column has patient DOB. Ac… Read more How To Display The Exact Age In Year Month Day Format In Sql Server

I am using Google BigQuery(Uses Standard SQL) but I have a Table with some data. Based on the data … Read more How To Use Delete And Insert Simultaneously In Query Script

I have a SQL grammar which do not have support for host variables. I want to provide support for ho… Read more Can Not Provide For Host Variables In Antlr3 Sql Grammar

I see the above error when I try to add to sqllite DB on android.I am using cloudant library. Here&… Read more Sqliteblobtoobigexception: Row Too Big To Fit Into Cursorwindow While Writing To Db

I am trying to perform a cumulative sum of values in SQLite. I initially only needed to sum a singl… Read more Cumulative Summing Values In Sqlite

I have an image resource ID in an SQLite database and I would like to display this image in a list … Read more Error In Displaying An Image In A Listview

This is my original code: String sqlQuery = 'SELECT * FROM data where company = ''+ Sel… Read more How To Hide A Column In Database

I have created a stored procedure that reads XML data as its input. I am having two issues that I a… Read more Creating A Query From An Xml Input Parameter In A Stored Procedure And Verifying The Output

I am looking to see the number of firstexam patients seen per month for a given date range this yea… Read more Showing Monthly Totals From Multiple Columns In Postgresql

I have some micro service (almost) system where each program has its own port. Moreover, not all po… Read more Are Nested Sql Queries Atomic?

Is there a way to integrate SSRS with Visual Studio 2010? If not, is there any other way to use SQL… Read more Integrate Ssrs With Visual Studio 2010