I want to get rows where date is equal to Previous day, Table Schema as below, -- create a table CREATE TABLE students ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL, xYear INTEGER, xMonth INTEGER,…
I am making a MySQL query of a table with thousands of records. What I'm really trying to do is find the next and previous rows that surround a particular ID. The issue is that when sorting the table in…
hope you guys are fine? OK.. i am using MySQL.Data client/library to access and use MySQL database. I was using happily it for sometimes on quite a few project. But suddenly facing a new issue that causing me hold on…
Say i have the following table, called graph: _id relates 1 {2, 3} 2 {4} 3 {5, 6} 4 {3, 7} 5 {} 6 {} 7 {} Here it is in graph form: graph My problem is to write a…
I have a query to show the average length of all the proteins which also exists in a second table mrna_pieces: SELECT AVG(protein_length) FROM protein WHERE exists (SELECT protein_id FROM mrna_pieces WHERE mrna_brokstukken.protein_id = protein.protein_id) I also want to show…
I am using BIGSERIAL as a Primary key and I want to make use of the deleted row's ids. Example of the table that I want re-use the deleted ids from the deleted rows: DELETE FROM my_table WHERE id=3; INSERT…
I have a table that has some file input data with file_id and file_input_date. I want to filter / group these file_ids depending on file_input_date. The problem is my date is in format of YYYY-MM-DD HH:mm:ss and I want to…
Probably it's a simple question, many people asked similar questions before, but it's very hard to find an answer for my specific case. I have a complex query like that: SELECT val1, val2, val3 FROM table1 LEFT JOIN ... WHERE…
I have a table tab1 in timescale db which has 3 columns tag, time, value. time and tag make up the pk for the table: (time, tag). There are more than 500 lakhs (50 000 000) of rows. I need…
I have a table "users": drop table users; CREATE TABLE users( id int, user_id int, phone_number VARCHAR(30), email VARCHAR(30)); INSERT INTO users VALUES (1, 999, 61412308310, '[email protected] '), (2, 129, 61477708777, '[email protected] '), (3, 213, 61488908495, '[email protected]'), (4, 145, 61477708777,…