How can I convert this to normal query? WITH cte AS ( SELECT agentID, SUM(bonus > 0) OVER (PARTITION BY agentID ORDER BY `year` * 12 + `month` RANGE BETWEEN 2 PRECEDING AND CURRENT ROW) flag FROM test ) SELECT…
I am trying to move my DB to Azure Managed Instance. I would like to know what should I do about this. I have the options of DB migration and DB restore to Azure managed instance. Please let me know…
my problem here is that I've got no idea of SQL queries but need to do something I'm assuming should not be hard. I've tried some of the recommended questions but I just can't really understand how to extrapolate it…
In my code first, I insert a record for a SQL table. then I want to update the same table after checking an API response. For that, I want to get the inserted record id and pass it to the…
I am trying to create a stored procedure in MariaDB, and I keep getting the error #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax…
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing: CAST(COALESCE(JSON_EXTRACT(item.price_details, "$.shipping.price"), 0) AS FLOAT) AS shippricecoalfloat COALESCE(CAST(JSON_EXTRACT(item.price_details, "$.shipping.price") AS…
i want to add the time, if there is free time as example im doing that with two textboxes where im entering the date Database 20.04.2020 - 20.05.2020 so there should be no possibility to add a time, i guess?…
I have an existing table that has many rows something like this: id Product Tel1 Tel2 Tel3 Tel4 1 A 1234 1234 1234 1234 2 B 1234 1234 1234 3750 3 C 1234 1235 1234 1234 4 D 1234 1234…
I have a Amount column in database which is in Varchar datatype, I am retrieving the data from table and I am casting for the amount should be returned as (12345.0,111.00) like this, so here I am casting with decimal,…
I have the following code to check if a SQL table exists: using (var conn = new SqlConnection(SqlServerConnectionString)) { conn.Open(); var selectQuery = $"SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '{tableName}'"; var cmd = new SqlCommand(selectQuery, conn); var reader =…