Lab Sql

I have a sql query that take the average in seconds between each datetime and group it by interval/… Read more Do The Same Than This Sql Query But In Javascript

I'm inserting value to my MySQL table from php as: $journey = $_POST['way']; $from = $_… Read more Sql Syntax Error In Mysql

Trying to get a basic table that shows retention from one month to the next. So if someone buys som… Read more How To Calculate Retention Month Over Month Using Sql

I am trying to update a record with VB.Net. This is the code. It doesn't give any error. But ev… Read more Update Oracle Statement Doesn't Work

I have a search screen where the user has 5 filters to search on. I constructed a dynamic query, ba… Read more Get Total Row Count While Paging

I have a column which is of 'DATE' type and I want to run a query on it comparing it with s… Read more Comparing Date With Sysdate In Oracle

I searched around quite a bit, it would be great if someone could link me to a solution or answer m… Read more How Do I Remove Single Quotes From A Table In Postgresql?

I would like to multiply each row by a single specified row, and then sum that product for each row… Read more Dot Product In An Sql Table With Many Columns

I'm trying to execute the following in sql server express 2012 SELECT t, MAX(CASE ItemID… Read more Cross Tabulation Msg 8120, Level 16, State 1, Line 8

Sl,No Name BirthDay 1 Jojin1 2013-05-12 00:00:00.000 2 jojin2 2012-06-12 00:0… Read more How To Use Convert Function In Sql Server?

When I execute my SQL, I get the below error: My exception is: [SQL]select bd.name aaa from bd_m… Read more Ora-00979: Not A Group By Expression When I Execute My Sql

I would like to substring from list of table type. Code is below @Description AS dbo.ListStringTab… Read more Sub String By Character From Table Type

I have 2 tables Departments ID Dept --------- 1 HR 2 Accts 3 IT Employee ID Name Depts … Read more Query For Comma-separated Ids To Comma-separated Values

I am using php 5.3.1 to connect to my SQL SERVER 2000 on remote machine. I use Windows XP. On usin… Read more Cannot Connect To Sql Server 2000

When a DELETE query is executed, from where exactly is the data deleted? Why is the data still visi… Read more In Oracle Sql, Why Are The Deleted (uncommitted) Rows Not Visible In Current Session But Visible In Other Sessions?

I am using the most recent version of PostgreSQL, and Pgadmin 4. And I am attempting to import this… Read more How To Import An Sql File Of The Northwind Database To Postgresql?

I have no idea why I am getting this error. Does anybody have any ideas? Error starting at line : 1… Read more Sql Developer Insert Data Error

I've come across this problem numerous times but haven't found a 'MySQL way' to sol… Read more Mysql Second Auto Increment Field Based On Foreign Key

Does anyone know what i'm doing wrong here, I have a webpage that gets currency data from a rem… Read more Truncate Table Then Insert Data Into Same Table Only Inserts 1 Record

We have an old application that was written in Delphi 7. It is currently connected to an old Oracl… Read more Getting Delphi 7 To Play With Sql Server Compact 3.5

I'd like to start a new React Native project including SQLite Storagee. I've already done t… Read more Impossible To Install Sqlite On React Native Project

I'm new in this comunnity and I need to work with a query that get data from a mysql database, … Read more How It Works A Mysql Query With Alias?

I have the following pl/sql block: BEGIN FOR I IN 1 .. 5 LOOP INSERT INTO TEST_TABLE VALUES… Read more In Oracle 10g, How Do I Accept User Input In A Loop?

Is there anything returned from MySQL/PHP on a INSERT query being executed? Here is my function whi… Read more Php Mysql Insert Return Value With One Query Execution

I have the following query: SELECT services.name as Service, services.logo_name as Logo, packages.n… Read more Mysql Show Null Results In Query - With Inner Join

I have the next table: Supposing these users are sort in descending order based on their inserted… Read more Sql Server Loop For Changing Multiple Values Of Different Users

I've made an SSRS report which has a text field parameter where users will enter a comma separa… Read more Using Ssrs Report To Pass In A Param Value The Is A Csv List To Sql Dataset

I have a simple table CREATE TABLE [dbo].[Tooling]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [nva… Read more Grouping With Partition And Over In Tsql

i have a data grid view and details for a particular table.i update the details, But it doesn't… Read more Refresh Data Grid View After Updating In Vb.net

I have a small problem. I am working with some manual testers who are untrained in programming/data… Read more Creating A Site To Query A Database Of Tables

I am making a database call through the following parametrized query. set recordset = Server.CReate… Read more Wrong Query Being Generated When Using Parameterized Query In Classic Asp

Through the following snippet, I am trying to run a query that either updates the data or inserts a… Read more Why Does Execute() Return True On An Empty Table?