This is how my data looks, emp_id,skills 1234,python|java|sql|R|javascript 5639,C|HTML|php|perl This is how data need to be loaded into the table emp_id skills python 1234 java …
Tag: sql
LEFT JOIN but take only one row from right side
Context: I have two tables: ks__dokument and ks_pz. It’s one-to-many relation where records from ks__dokument may have multiple records assigned from ks_pz. Goal: I want to show every row from …
Using BETWEEN in native query in JPQL
I tried to make a query using BETWEEN in JPQL, I already tested it in SQL and it works, but when I implemented in JPQL I got an error: Caused by: javax.persistence.PersistenceException: Exception […
how to check a date is in current financial year
I am trying to check a condition if given date is in current financial year i.e april to march. but not getting any idea how to do code select nvl(Count(1), 0)+1 from ASET where IPE=’O’ and irt in (…
Develop a single host multiple client MYSQL database
Please forgive me if the title is not correct. I am still trying to understand how this works. I have installed MySQL workbench and the MySQL server on my laptop. I have successfully created a database that store driver details, as per the picture. I can access this info only one my laptop. However, I would a…
How to map/join two tables and filter by parameters using dapper
I want to join two tables that have a relationship with each other, In the Customer table, there are two columns for deleted and approved. Get the Customer that are approved and not deleted then match the Customer with the Loan table Using CustId (Both Tables has CustId) and Filter by supplied parameters Dele…
How to make an SQL query to get only 1 row with specific data?
I have the following MySQL query: SELECT work_from, work_until, restaurant_id, from_date, to_date FROM restaurant_working_times WHERE restaurant_id = ? and restaurant_id is not null and `week_day` …
Use inputbox to filter in asp.net core razor with dapper
I have a query that is already getting data from the DB, Now I want to filter the data using a checkbox from the razor page. Below here is the checkbox I am already getting the values of the checkboxes via string[] Requestloans But the problem is how to filer db with the RequestLoans array using dapper. If th…
find the highest occurrence of a point type
How to get the highest repetition for a point type data in PgSQL Need to calculate the most repeated coordinate (more precisely within a range of 100 meters) Sample data column name coordinates …
How do I get the matching id for every record?
My table is called platform_statuses, here is its schema: And this is my query, I would like to also get the matching id for the returned records. Also note that the abs function you see in the query is a custom one I got off this answer. Here is its definition: Answer I understand that, for each account and …