Lab Sql

I want to know that what is the use of right join exactly as we can get the same result from left j… Read more What Is The Use Of Right Join Exactly As We Can Get The Same Result From Left Join

Using Cognos 11.1.7 and the database is DB2 on IBMi DQM Trying to figure out how to get Framework m… Read more Cognos 11.1.7 Framework Manager Change The Table For The Query Subject, Type Data

I have this statement: SELECT COUNT(AccedentId) AS NumberOfAccedentInYear FROM … Read more Return 0 When Result Is Empty

I have created SSIS Package (.dtsx) which is stored on my hard drive. I want to execute it by using… Read more How To Execute A Package In 32-bit Mode Using Dtexec.exe?

Is there an elegant way in SQL Server to find all the distinct characters in a single varchar(50) c… Read more Sql: How To Get All The Distinct Characters In A Column, Across All Rows

I have two tables Person (contain oldest date (farthest in future) when person moved OR WILL moved … Read more Delete Where Both Columns Match

I was given a task to use cursor to duplicate tables. (Don't ask me why or suggest me to use ot… Read more Sql - How To Insert Values While Checking Condition Based On Another Table? If Null Generate New Id

I want to select asynchronous some data of a sqlite3 database. But since db.each is a asynchron fun… Read more Sqlite3 - Promise For Asynchronous Calls

I am reading from a csv file and sending data as table variable to a stored procedure. From what i… Read more Table Valued Parameter: Sending Data In Small Chunks

A table Jobs which have 2 column JobId, City when we save job a job location may be multiple city l… Read more Get Count Of Different Values In Comma Separated Row In Mysql

Trying to get the moving average on a per X months basis using SQLite. Problem is i cannot seem to … Read more Sqlite Moving Average

Assuming a data structure of the type stock_name, action, start_date, end_date google, growing, 1, … Read more Group Consecutive Time Intervals In Sql

I have a series of history tables in an oracle 9 database. History_table_00 contains last months da… Read more Dynamic Table Name In Select Statement

I have a question in hand where i need to restrict the number of projects assigned to a manager to … Read more Allow Only 3 Rows To Be Added To A Table For A Specific Value

Is there a built-in feature, or way to simulate RLS(Row Level Security) in SQL Server 2008 as found… Read more Implementing Row Level Security In Sql Server 2008

That's my basic (Database First) diagram on SQL Server: When I Update Model from Database usin… Read more How Can I Get A List Of Linked 1-n Elements?

I need to convert date time to nvarchar on sql server like 2011 Oct 24 but I'm not able to con… Read more Customization On Sql Datetime Format How?

I have four tables: dbo.Projects dbo.Locations (id, location name) dbo.Purpose (id, Purposename) … Read more Create And Execute Function In Sql Server

I have just installed a new SQL Server instance with SSRS to replace an SQL Server instance. I nee… Read more How To Migrate An Existing Ssrs Setup To A New Server?

Hi current i have code which will display the sum of records for last one hour in 10min interval. S… Read more Sqlite Query Need To Tuned A Bit

I recently had an issue with some SQL logic over here: MySQL multiple WHERE AND/OR condition logic … Read more The Correct Way To Store Items With A Filterable Attributes?

The Problem I have a query that returns 17 records. When I use MyBatis with a map that has an it … Read more Mybatis Doesn't Return All The Results From The Query

is it possible to find out the amount of rows that will be deleted in each table when one row is de… Read more Find Out How Many Rows That Will Be Deleted(on Cascade) If One Row In A Table Is Deleted

I'm writing a program that creates a sqlite3 database through python. I have one table of Autho… Read more Using Foreign Keys In Sqlite3 For Python

I am making a test. I have all tests in rows, so my rows looks like this; ID | TEST -------------… Read more Explain For In Oracle

Possible Duplicate: Truncate (not round) decimal places in SQL Server Can't figure this out. … Read more Microsoft Sql Rounding Off To Whole Number, Need To 1 Decimal Place

I need to select all the columns names only from a SPLANNING_ROOMDATA2 table in such way that those… Read more Sql Server Query: Get A List Of Columns Which Don't Exist In Another Table's Field

I don't know where are my mistakes. I am trying to store the lyrics.db file in my DB_PATH when … Read more Sqlitelog 14: Cannot Open File At Line

Can anyone help me correctly write the correct syntax for a CHECK CONSTRAINT IN MYSQL. My table is … Read more Check Constraint For Mysql

I need your help and advice. This is my first project in jersey. I don't know much about this t… Read more Need Help About @get @post @put @delete In Restful Webservice

Im trying to get the date and the time using C# , and then insert it into a smalldatetime data type… Read more Datetime.now Into Smalldatetime?

I'm using Sequelize with sqlite and when i try to insert data to the table gives me the error E… Read more Sequelizedatabaseerror: Sqlite_error: No Such Table: Users

I have two tables: Events (ID, Name, Time, Recorder) Video (ID, StartTime, EndTime, Recorder, Filen… Read more Sql Join Tables On Time Between Start And End

In my PhpMyAdmin database I have 9 tables. 8 of those tables are relevant to me at this moment. I w… Read more Efficient Query, Table Bridge/indexing And Strucuture

I have a fairly good feel for what MySQL replication can do. I'm wondering what other database… Read more Which Database Has The Best Support For Replication

How to convert the following sql query to lambda expression? SELECT Username, COUNT(Username) AS Co… Read more Convert Sql Query To Lambda Expression

How could a stored procdure run in 10 seconds via Management Studio, but take 15 minutes via a Tabl… Read more Big Difference In Execution Time Of Stored Proc Between Managment Studio And Tableadapter

I have looked at many videos and answers, on the web I now have a working example. I wish to drag a… Read more How To Add Record To Sql Server Compact

I have a paradox table from a legacy system I need to run a single query on. The field names have … Read more Delphi: Paradox Db Field Name Issue (spaces In Field Name)

I have this query SELECT COUNT(*) from `login_log` where from_unixtime(`date`) >= DATE_SUB(NOW(… Read more Combine 2 Mysql Queries

With reference solution I've posted in my previous post resulted in one more situation. While … Read more Insert From Dynamic Query In Postgres

i have one excel file that contains a1 to a5 rows with values now a6= sum(a1:a5) I want a6 value to… Read more Insert Data From More Than One Excel Sheet Of One File Into Table Using Ssis?

As i am having AMD processor in my laptop i am using GENYMOTION as an emulator. I have stored the d… Read more How To See The Data Stored In Sqlite In Android Studio Using Genymotion As Emulator

I want to use the following SQL statement in a small C# application. The SQL statement runs perfec… Read more C# Parameterized Query With Domain Aggregate Functions (dmin)

I am working with loading XML files contents into a table in a SQL Server database, for which I wan… Read more Deleting And Restoring Foreign Key Values In Sql Server Database Table

I am just wondering any good tools or software that you can recommend me to protect / encrypt my st… Read more Sql Server : Encrypt / Protect Stored Procedure

string que = 'SELECT Name FROM StudentInfo where StudentNo=textBox1.Text '; Every time I r… Read more Getting Value From A Database Using Textbox

i have table with following structure and data: I would like to get grouped data by months in give… Read more Sqllite Strftime Function To Get Grouped Data By Months

How to convert string '۱۳۹۴' to '1394'? I try change collation but does not work. P… Read more Convert Unicode String To Ascii In Sql Server

I have a hive table, htable that's partitioned on foo and bar. I want to create a small subset … Read more Hive - How To Efficiently Create Table As Select?

I have a table vw_Lab_Space which lists out all of my labs, and has a Lab_Space_Id column which is … Read more Need Help Creating An Outer Join To Count Spaces

I could see the below entries in the ULS log 02/08/2010 14:36:46.12 w3wp.exe (0x15F4) … Read more Issue With Sql Stored Procedure

this is my docker-compose file.yaml: version: '3.3' services: db: container_name: db… Read more Run Java In Docker-compose

I am trying to remotely connect to a Microsoft SQL Server from Node (using node-mssql). var sql = r… Read more Which Ip To Use To Remote Connect To Sql Server?

I am getting this error while I am fetching value from resultset. Error : com.microsoft.sqlserve… Read more The Column Name Is Not Valid - Error

Im working with a Sqlite database in C#, when I insert my date into it, everything works fine (in t… Read more Sqlite Cuts Off Zeros, When Updating Database

I have a table names Employee which is referenced to almost 85 tables in database. I want to make f… Read more Drop And Recreate Constraints Script

There is a column that can have several values. I want to select a count of how many times each dis… Read more Sql: Select Sum Of Each Individual Value Of A Column

I have a table with is simply a list of dates and user IDs (not aggregated). We define a metric ca… Read more Google Bigquery: Rolling Count Distinct

I am developing a web app that interfaces with an ERP production database and the data is being ret… Read more Making A Laravel Model Use Complex Query As Table

I want to create an Express REST API and will use MSSQL for the database part. I use the mssql modu… Read more Transaction For Prepared Statements Using Node Mssql