Following are my 2 tables CREATE TABLE temptext ( id text ); CREATE TABLE temptext2 ( id _text ); My insert queries are INSERT INTO temptext (id)VALUES ('a'); INSERT INTO temptext2 (id)VALUES ('{c,d,e,a}'); I have 2 queries that run perfectly…
My app is working fine, but anyway I got this error. I'm using a future builder to read from database and display on screen the data, not the list but 1st item, and if i do some actions the counter…
I would like to use a division query to have all the customers who bought all products. The template is the following : SELECT * FROM Customers AS A WHERE NOT EXISTS ( SELECT * FROM Products AS B WHERE…
I have this 3 tables and I want to get the same subjects by given student_id For example I will select Vince (student_id = 1) And Jane (student_id = 3) the return value should be the subjects english and science.
My concern: if ($case=='private') { $langtitle = 'title'; } else { $langtitle='title_gov'; } if it is Government (falls under else case above) I want to select, 'title' as well as 'title_gov' with Select in query as, Images::select($langtitle ,'id', 'title') ->groupBy('id')…
I have a PostGIS table that stores the locations a device has passed through in the following way: ts lat lon 2022/12/23 10:04 -3.2654 -79.9234 2022/12/23 10:14 -3.2654 -79.9234 2022/12/23 10:24 -2.95592 -79.6833 As the device is transmitting every 10…
I have a DB column named ask_code and ask_grouping which says if the ask_code is grouping or not (like a boolean for G = yes). How I do a SELECT query to get all the ask_code by grouping? Something like…
array:5 [ 0 => array:1 [ "location_id" => 1 ] 1 => array:1 [ "location_id" => 4 ] 2 => array:1 [ "location_id" => 6 ] 3 => array:1 [ "location_id" => 7 ] 4 => array:1 [ "location_id" =>…
I have a large database with around 75K points. This database represents a time series associated with countries with the following format: |country | value | date | I am using a fastapi API to serve this data on my…
I have a large database in which I use LIMIT in order not to fetch all the results of the query every time (It is not necessary). But I have an issue: I need to count the number of results.…