I have a filter with three check boxes, each of which has a Value “question”, “partnership”, “complaint”. but when I select two data from the check box (ex.complaint & question) sent to the …
[SQL]Select same date from one row
I created 3 tables: People: ID INTEGER PRIMARY KEY, SURNAME VARCHAR(15), Car: ID INTEGER PRIMARY KEY, NAME VARCHAR(15), Transaction: ID INTEGER PRIMARY KEY, ID_CAR INTEGER, ID_BYUER INTEGER, …
Delete statement in SQL Server [closed]
I saw a delete statement written in below format and I need help in understanding it. create table t1 (id int); create table t2 (id int); insert into t1 values(1); insert into t1 values(2); insert …
How to count missing rows in left table after right join?
There are two tables: Table education_data (list of countries with values by year per measured indicator). create table education_data (country_id int, indicator_id int, year date, value float ); …
SQL nested WERE
I’m a beginner in SQL and I don’t understand the nested WHERE request: When I first request: SELECT movies.title, people.name FROM stars INNER JOIN movies ON movies.id = stars.movie_id INNER JOIN …
Codeigniter MySQL filtering data as per user ID in the session
I have following function in my model to select records as per the user ID in the session. public function getOfficer() { $usr = $this->session->userdata(‘id_user’); $userArray = $…
MEDIAN() window function on stable Maria DB
I need to perform a MEDIAN calculation as part of a query. My developer told me this is possible with Maria DB 10.3.3 but my server admin told me they can upgrade only to 10.3.2 since that is the …
Drag and Drop not working with external monitor [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question I’m working on a small project for my studies. It’s the first …
group results in sql
In my settings table there is a field whose content is: – Law 1 – Law 2 – Chemistry 1 – Chemistry 2 – History 1 – History 2 – Modern language 1 – Modern language 2 – Modern …
Codeigniter MySQL select max using varchar type value
I want to select max auto_no from the following varchar type column in my codeigniter model +————+ | auto_no | +————+ | 2020-00821 | | 2020-00822 | | 2020-00823 | | 2020-00824 | | …