Lab Sql

I have a need to transfer the following data set: in which only the highlighted lines are the one … Read more PIVOT Oracle - Transform Multiple Row Data To Single Row With Multiple Columns, No Aggregate Data

Hello and thank you for your time, I have been searching everywhere online for an example, where a… Read more SQL Server: Can I Use EXEC To Run An External Application?

I want to write a SQL query where if the datetime is not been assigned I want to replace a string w… Read more MySQL IN BETWEEN With No Condition

I want to store hierarchical, two-dimensional scientific datasets in a relational database (MySQL o… Read more Storing Scientific Data In A Relational Database

I am developing a large django-based project. On my laptop I use SQLite3 as a database. I have crea… Read more Django Migrate Schema From Sqlite To Postgresql

I have been searching long and hard for an answer regarding the processes full-text index uses to i… Read more How Does SQL Server Full-text Index Actually Index The Words In A Catalog?

This has me stumped. I am trying to set encoding for my Sqlserver connection and all that I have tr… Read more Cakephp Sqlserver Encoding

I found it hard to find a fitting title. For simplicity let's say I have the following table: c… Read more Compare Rows And Get Percentage

In this type of code, AND Orders.ShipDate >= DATEADD(Day, Datediff(Day,0, GetDate() -6), 0) It … Read more Datediff GETDATE Add

I have two columns, id integer and version text. I am trying to convert the strings in version into… Read more Substituting Value In Empty Field After Using Split_part

I've just started a module in school on Oracle, I would like to ask for some help as I'm re… Read more Learning Oracle, Setting Boolean Based On Date

I have a Java class with instance fields (and matching setter methods) that match the column names … Read more Mapping A Row From A SQL Data To A Java Object

We have the following account table (MySQL RDBMS): +----+-------------------+----------------+-----… Read more How To Create New Comma-separated Column From Existing Data?

Is there a way to determine whether a record was matched or not (whether the record was inserted or… Read more Determining SQL MERGE Statement Result

I have restaurants for which I have the following information in postgis: Last name longitude latit… Read more How Do I Search For Restaurants In A Region In A Country?

I'm sure this is a simple issue, but I'm trying to combine 2 columns into a new output colu… Read more Assign Value To SSIS Script Component New Output Column

I want to split the below string (present in a single column) separated by spaces from the end. For… Read more How To Apply Split_part Function From End Of String In Postgres

Firstly please understand that SQL is not one of my strong areas at the moment and i am a little un… Read more SQL Insert? Insert Data From One To Another

On a windows store app project i get a JSON from a webservice that looks like this:http://paste2.or… Read more Sqlite Not Recognizing Generic List

I wonder if the following is possible with fts(3/4) for SQLite. I created a table with some data us… Read more SQLite Full Text Search Catalog