I have a DB that stores student records and there are 4 tables that I need to query from to get a student grade report. The tables being JOIN are school, students, subject, student_score, class The table structure are as…
I have a list of alphanumeric strings that includes two special characters + and -. The input, as shown below, represents part numbers for our company's products. I would like to extract the individual components as an output. There are…
I'm writing simple rock-paper-scissors game. In this piece of code I'm trying to assign id value of the clicked img to a variable using .forEach method. It just doesn't work. If statements does work but somehow string doesn't add to…
I have got a very large string, it contains about 13000 times different data of the same kind. I have now created a function to split this string into an array of 13000 elements. Now each element of those 13000…
can you give me an example request showing how I can combine two duplicate lines merge one? id name no 123 aaa 1,2,3 124 aaa 4,5,6 125 aaa 7,8,9 i want this id name no 123 aaa 1,2,3,4,5,6,7,8,9 I researched…
I am using multiple concat with like but I am not getting all the output from the table. I am using below SQL query below in the database. select company_id as ID, concat( c.list_rank, '|||', c.company_name, '|||', c.company_size, '|||', c.industry…
I want to add or insert thousands commas in between digits of a number as long as I input digits like some calculators (see the image). For example, when I begin inputting the digits 793, the code inserts automatically a…
what do I expect? (As I don't have codes I had to show in images what I need) API response: https://raw.githubusercontent.com/leufrasiojunior/dashboard-clix/Testes/public/result.json summarize the number of times a given criterion appears, count how many times it is compliant or non-compliant, add…
I need to collect data from different tables, without duplicates and with a column that collects the presence where I've found each item. So, this is my scenario: TABLEA itemId name 1 John 2 Sam TABLEB itemId name 1 John…
concat(array) vs push(...array) I've been using .push(...) method to concatenate 2 arrays unpacking the second array, using the three dots notation, and passing that as the argument (array1.push(...array2)). But I just noticed that .concat(...) does the same thing, at least…