From DBeaver Community, I access my database and create a new SQL query. I write the corresponding code for the CTE I want to create, but it constantly shows a syntax error. I've tried everything, but I can't find the…
I have a MySQL table like the following prod price1 price2 price3 ---- ---- ---- ---- AA 100 200 400 BB 200 300 655 How to write a query in MySQL so that the table appears vertically like this? prod…
I am trying to write a MySQL query for graphing purposes, the graph is for a single column but at different times of the day. I have a table which is measuring the State of Charge of a large battery…
I have table as follows (let's call it old data). UNIQUE_PJT PROJECT JOB_TITLE SALARY_A SALARY_B IT_9810_PR IT_9810 Programmer 10000 6000 IT_9810_AC IT_9810 Accountant 9000 4500 IT_9810_SPR IT_9810 Programmer Sr 15000 8000 IT_9810_SR IT_9810 Sales Representative 12000 9000 This data extends…
I have made a laravel application which save data in db as UTC. My client is in South Africa and he wants the records to be displayed in South Africa timezone. Any body guide me related to this. Thanks I…
I'm building a stored procedure that returns the lowest price of each product and show their respective store info and date. This SP should allow optional parameters for StoreCity and ProdType. I'm a bit stuck on the SELECT query. These…
//night shift employee id from_time to_time task 1 21:00:00 22:00:00 - Cleaning(some task) 1 22:00:00 23:30:00 - Fumigation(can be some other task also) 1 4:00:00 7:00:00 - Disinfection 1 2:00:00 4:00:00 - Break 1 23:30:00 2:00:00 - Fogging //day shift…
My MySQL table looks like this: _id _masterid 17 null 18 17 19 17 20 null 21 null 22 20 23 17 24 20 25 20 Is it possible to order it with a single query so we get this…
I have been trying for over a week to replace thousands of grammar errors in a data feed file of 103,927 products. I'm stuck on how to put a space between a lower case letter or number, period, [NEED SPACE…
I am trying to do union with DB query builder because with models is not working the union with paginate/cursorPaginate. I have this but give an SQL error because Laravel is not building the right query (maybe my fault, I…