sqlfiddle | This library is powered by Entity Framework Extensions | SQL Database library

The table has many columns, but for the problematic part let's assume only two, [ID] and [dependency].

[Dependency] means which [ID]s should be listed before this [ID].

Each row has its unique [ID] but it might have none, one or more dependencies in the [Dependency] column

ID Dependency 1 4 2 null 3 1,2 4 2 5 1,2,4

Expected Result

ID Dependency 2 null 4 2 1 4 3 1,2 5 1,2,4

I have no prior experience in Postgres, I found this very useful:

...

I want to update records in table Users that are not present in table UserActions (see sqlfiddle demo or sql and data at gist.github)

My tables

...

I have a windows service (VB.NET) to copy data from a SQL table to another SQL table (in a different database & server). When I start the service it just give me this error:

Error converting data type varchar to numeric.

PS : I'm surprised with this error since I don't see any varchar data type in my source table.

Source Table(NOR_LABOR) columns and data types Sample Source Table : http://www.sqlfiddle.com/#!18/bd4fb/1

Destination Table(ALL_LABOR_DETAILS) columns and data types Sample Destination Table : http://www.sqlfiddle.com/#!18/7eb72/1

...

I have the following tables:

...

I am trying to select the record but not getting the record I wanted. here is my sqlfiddle http://sqlfiddle.com/#!17/5296a/1

so when I selects the record using below query

...

I have the following table that I would like to compare

I have to compare dates per employee and if the date range is less than 60 days it has to extract the employee. example:

• the employee with number 4 has 3 records (4479,4192,1982)
• The combination of these 3 records (4479-4192, 4479-1982, 4192-1982) the dates must be compared and if one of them is less than 60 days, the employee must be extracted.

below the example table: http://sqlfiddle.com/#!9/b44d4e

id idEmployee date 1228 2 2020-06-11 21:10:53 3382 2 2020-06-11 12:37:04 2223 2 2020-08-17 21:10:57 4479 4 2020-08-17 12:37:08 4192 4 2020-07-29 12:37:08 1982 4 2020-07-29 21:10:56 2627 8 2020-04-16 12:37:02 474 8 2020-04-16 21:10:49 1002 10 2020-05-29 21:10:52 3150 10 2020-05-29 12:37:04

pd: mysql database

Any help or suggestion how should I make the query?

...

Apologies for the sloppy title, I can't quite think of a cleaner way to word it.

I have searched this issue and found people talking about it, but the examples are all with simple queries that aim to retrieve singular values, or beyond my grasp. I would be really appreciative if someone could tip me off as to how this can be done neatly.

Here's the SQLFiddle I made with my problem boiled down to remove all unnecessary elements. The table arrangement is

Books

• ID int
• Title str

Alternate_Titles

• Books_ID int
• Title str

Tags

• ID int
• Label str

Books_Tags

• Books_ID int
• Tags int

Authors

• ID int
• Name int

Books_Authors

• Books_ID int
• Authors_ID int

The query I'm trying to write would yield results like

...

function sum(boolean) does not exist LINE 13: ISNULL(SUM(s.Offset = 0), 0) w1, ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

I'm trying to create a weekly cohort analysis that would show the weekly login stats. As you can see this is what I want to achieve:

This is what I have found, and what I'm trying to re-create:

http://sqlfiddle.com/#!9/172dbe/1

These are the tables that I'm trying to take the data for:

And this is what I have refactored so far:

...

I have the following problem: I have a timeline of a machine's lifecycle events:

...