Category: DBMS

I’m trying to get and print data from a row “status” on the table “printer” and it keeps saying “There is no row at position 0.” Dim conn As New deepconnection() Dim …

Evening guys and girls! I’m trying to combine both a SELECT and UPDATE, however the join is causing me a major headache and hoping someone can help. My table is within wordpress post data containing …

I have a database with 1 billion key val pairs with 20 million unique keys. On average, each key is associated with 50 vals. key val key1 val1 key1 val2 key1 val3 key2 val2 key2 val7 . . . I ran the …

I’m trying to display the nationality of an employee from the database into the dropdown, which contains all country names. I had a separate page to store the country list and included it in the edit …

I would like to know how many users joined each day over the last 7 days. Something that looks like this | day | count | | 6/19 | 53 | | 6/18 | 23 | | 6/17 | 55 …

I need to get data from 2 tables where I want to fetch the cost group by month. The 2 tables are spare_stock_history (spare_id, amount, created_at) and base_inventory (id, unit_price) I need to get …

I have set up a small section within my application where a user can add a link and submit/apply for a job. I then want to extract information from the link the user inputs and save it within my …

I have a table as such: firstname lastname values john doe first john doe second john doe third joe public first joe public second …

Morning, I’m having trouble understand the best way to join the following two queries together. The first code shows me the last entry by name and I’d like a count of each time the name is listed. In …

Trying to calculate the sum of n x k-combinations (ie. non-ordered) for m elements. To calculate a k-combination, I need to create a function which calculates factorial. The code is quite simple, and …