I have this query (mysql): SELECT `budget_items`.* FROM `budget_items` WHERE (budget_category_id = 4 AND ((is_custom_for_family = 0)
I have the following columns in my DB Codes year | code | ---------------- 2009 | 10001 | 2009 | 10002 | 2009 | 10003 | 2010 | 10001 | 2010 | 1000
I have a table where as codes are present in the form of 78,7244,d345 by default few records are found where the codes are start with 0072 . I have to delete st
I have a datagridview which filled by SQL table. When I search a value with a textbox in the data and update/insert the some values and use fill function again
in my database there are 2 tables : posts, room Posts tables include ID and Title columns and includes many rooms and hotels titles and IDs. In the room table t
I have this piece of code which acquires connection from EF Core DB context and executes select on the received data. var conn = _dbContext.Database.GetDbConnec
I want to join multiple tables in laravel with query builder. My problem is that my code only works if I specify the id myself that I want like this: $datauser
I would like to calculate the mode/median or better, most frequent observation of a categorical variable within my query. E.g, if the variable has the following
I'm trying to parse json data in a column with Druid SQL in Superset SQL lab. My table looks like this: id json_scores 0 {"foo": 20, "bar": 10} 1 {"foo": 30, "
I'm trying to create a stored procedure that backs up a database, however whenever I execute it, the folder I'm trying to backup to remains empty. Here is my st
I have two tables match_score and match_condition I want to update table match_condition and set values of innings, first_4, etc. Here's the example in which I
I would like to get first day of continuous date sequence. Query is valid for one month. I am using SQL Server 2014. Table example: Id | VechicleISO | RideISO |
I am migrating some data. I have a table data which has quite a lot of columns to reference other tables. And those other tables are being changed and simplifie
Error : AnalysisException: Recursive view management_db.v_extract detected (cycle: management_db.v_extract -> management_db.v_extract) Query outisde of the v
I've googled for it, both couldn't find an answer. How can I list tables used by materialized view (must not use the information_schema views) in PostgreSQL? Th
I'm going to rename a MySQL 8.0 table via Flyway SQL script: RENAME TABLE aaa TO bbb; and it's supposed to be run on env many times - but such the script is no
I try to pass argument $1 to jsonpath-expression: SELECT 1 FROM %s.orders AS O WHERE order_info @? '$.items[*] ? (@.ProductID == $1)' but it doesn't work. P
I have the query below and keep getting a divide by 0 error but I'm not sure how to add something to bypass that select x.year, x.month, x.period, coalesce(
I have two columns price and sold_count for the product table. How do write sql query to find the top 3 shops having highest Revenue (calculat
What is the solution if you see the code below there is a value (2000) then I want to change it to textbox so I can custom value. Thanks jack Dim sql As String