I was asked this question in a job interview: There is a table with vehicle names mentioned in a column. Output when we check for name=car we must get as 4 i.e the maximum count of continuous occurrence of 'car'…
I am using IN operator in a non conventional manner, with a literal value on the left side and columns on the right side So instead of: (table1.id = 123 OR table2.id = 123 OR table3.id = 123) I use:…
I can't execute sql query, that has to rename the table to the same name as type, that already exists. I have not found any rules or comments about the same name for different things in postgres. CREATE TYPE ratings.processed_sport_bet…
I search a solution for my problem in SQL (postgresql). I have a logs table with the following columns: deviceId id code timestamp device1 1 12 1672597471000 device1 2 11 1672597471001 device1 3 8 1672597471002 device1 4 2 1672597471003 device1…
So i wanted to make an API with a search function with SQL queries using node express, this is what my code looked like: app.get('/search/:query', (req, res) => { pool.getConnection((err, connection) => { if(err) throw err console.log(`connected as id ${connection.threadId}`)…
I would like to know how to sort values in mysql query. I have a table tasks and has column cost which can have null or number values other column status have 2703, 2702, 2701 Based on condition, the order…
I have many records in the table. I was grouped by continuous date. example : begin_at (From Date) end_at (to date) 2023-05-05 00:00:00 2023-06-18 00:00:00 2023-06-11 00:00:00 2023-06-18 00:00:00 2023-06-12 00:00:00 2023-06-18 00:00:00 2023-06-13 00:00:00 2023-06-18 00:00:00 2023-06-14 00:00:00 2023-06-18…
I apologise for the incorrect use of sql terms, I'm still a novice. So, I produced a ddl script from a relational model, converted it to MySQL and tried to "run" (the app Im' running it at is called phpMyAdmin)…
I am querying a table with around 4M data with two types of skuID and using order by on version as there are around avg 5k versions of data for one skuID and fetching the top most versions using limit.…
I have Postgres data imported from a spreadsheet, where section headers have been imported along with the data. Is there a way to move the section headers to their own column? I have looked at window functions and I have…