Skip to content

Tag: sql

Removing near identical values from mysql table

Is there a way of removing near identical values from a table in mysql? My table has records more than 10K out of which one of the company looks like this: on using describe tablename I get this: the names of the company are same however I would like to delete the second instance from table, thereby keeping j…

How to cast this integer value to date in MySQL

i have airbnb data and i want to cast column last_reviews (which datatype is int) to date this is my sql code http://sqlfiddle.com/#!9/b5ea42/31 how do i cast int > date? or how do i create last_reviews column as datatype date? Answer The last_review date seems to be the number of days since 1900-01-01 so …

Multi-column IN/ANY postgres query

Sample table schema: Requirement: Fetch rows that match any of the tuples (col1, col2) presented in an array. SQL: I want to write this query in Go using the “database/sql” package with “github.com/lib/pq” driver, and that is where I am facing the problem. I can easily do this for sing…

How to combine multiple INSERT INTO’s with prepared statements?

Using Dapper, is there a way to form this into one query with the prepared statements? The length of userIds is dynamic. Answer One of the many advantages of Dapper over straight ADO.NET is the simplicity of inserting a list of data to a table. You just need a list of a class <T> where the properties of…

SQL – select based on value existence in another column

I want to create a SQL query to identify wells which do not have A3 events. I am using SQL server. I have tried multiple ways like checking count, comparing with event A3 but still unable to get what I want. From below example desired result would be W3 and W4 Site Event W1 A1 W1 A2 W1 A3 W2

What is the value of schema tests in dbt?

When would you want to use a dbt schema tests (unique, not_null, accepted_values, & relationships) when you could instead use SQL schema constraints? For example, here are some SQL schema constraints that could replace each of the dbt schema tests: unique: UNIQUE constraint not_null: NOT NULL constraint a…