Category "sql"

How to I order by a sql table multiple times?

I don't think I worded it correctly but how do I use order by to sort a table multiple times by a different dimension. For example if I wanted to sort by type o

Two-part conditional sql statement

The statement below is querying a log table and I'm trying to get the max budget depending on the scenario if falls within. Error message: Expressions referenc

Two conditions in where tag of Liquibase

I want to add two conditions in where tag of liquibase and exception is thrown: Reason: liquibase.exception.DatabaseException: Unknown column 'uid' in 'where cl

return the row where before and after value is lower

I have a table that looks like this: name val 1 1 2 2 3 1 4 2 5 2 6 10 For each row,

How to update the timeout field in the attendance table for a given user_id, logdate and status using if else statement?

I have been trying to update the timeout for a given user_id, logdate, and status but my update statement is not working or may be my other if else are not corr

Error with creating a laravel foreign key

I'm trying to create a relational database and this is the error i get SQLSTATE[HY000]: General error: 1005 Can't create table somedumbtable.meals (errno: 150

Select item that is different in each of group by a column

I have this sample table +--------+-------------+ | DBName | Description | +--------+-------------+ | A | Car | | A | Boat | | B

django annotate whether exists or not

I have a query I'm using: people = Person.objects.all().annotate(num_pets=Count('pets')) for p in people: print(p.name, p.num_pets == 0) (Pet is ManyToO

get the most common value for each column

I'm attempting to create an SQL query that retrieves the total_cost for every row in a table. Alongside that, I also need to collect the most dominant value for

Check if a number is prime or not in mysql

I am wondering what's the best way to check whether a number is prime or not using sql. I was able to generate the sequence of numbers from 1 to 1000 but I woul

Is there a way to search one table for certain values, and if successfully found, then update a different table?

Good afternoon all, This is my first time using SQL, so forgive me for being new. I have three different tables that I've created: CREATE TABLE employee (ID int

How do I produce a new column with values based on a Partition of one column while also based on the values of two additional columns (BigQuery)?

I have a table that records all the different statuses for a list of Jobs with timestamps. So the ID column has many Ids that appear several times as their stat

Category "sql"

How to I order by a sql table multiple times?

Two-part conditional sql statement

Two conditions in where tag of Liquibase

return the row where before and after value is lower

How to update the timeout field in the attendance table for a given user_id, logdate and status using if else statement?

Error with creating a laravel foreign key

Select item that is different in each of group by a column

django annotate whether exists or not

get the most common value for each column

Check if a number is prime or not in mysql

Is there a way to search one table for certain values, and if successfully found, then update a different table?

How do I produce a new column with values based on a Partition of one column while also based on the values of two additional columns (BigQuery)?

GBQ Transpose Dynamically without Execute Immediate

Smarter SQL UPDATE between two tables (bill and bill rows)

Target row updated by multiple source rows

Cannot connect to SQL Server except with domain admin account

On delete cascade on foreign key not working [duplicate]

Hive SQL regexp_extract (number)_(number)

How to order by many to many relationship in Sequelize?

width_bucket not returning buckets of equal width

Category "sql"

Other Categories