Mimer SQL is a relational database management system (RDBMS).
Questions tagged [mimer-sql]
7 questions
1
vote
2 answers
Create view and show max value - mimer sql
I would like to create a view that presents name and number of a "department" with the max value.
drop view highestvalue;
CREATE VIEW HighestValue AS SELECT s.dept, d.name, SUM(s.quantity) TotalQuantity
FROM sale AS s
INNER JOIN dept AS d ON…
Boohz12
- 19
- 5
1
vote
2 answers
SQL error for creating table and inserting values in it. Error -12233 and 12101
So I'm trying to create a table in SQL and then insert values into it. However, I seem to be getting this error:
[Error Code: -12101, SQL State: 42000] Syntax error, 'CHECK' assumed
missing
and
[Error Code: -12233, SQL State: 42000] The…
JubbeM
- 15
- 6
0
votes
0 answers
Binding query parameters by name with Mimer SQL Data Provider
Currently only [A] has been tested. Is [B] possible?
[A]:
SELECT code, country, currency_code FROM countries
WHERE currency_code = ? AND code = ?
[B]:
SELECT code, country, currency_code FROM countries
WHERE currency_code = :currency_code AND code…
Ch. W. Lee
- 1
- 1
0
votes
0 answers
Fetch ROWID in mimer-sql
How to fetch ROWID / ROWNUM in mimer-sql? I need too update table based on ROWID, so need to fetch rowid and update the specfic rowid only.
0
votes
1 answer
mimer sql - create new table with average price
Create a new table that contains all items that cost more than the average.
My previous queries:
CREATE VIEW AveragePrice AS SELECT * FROM Item
WHERE price > (SELECT AVG(price) FROM Item);
SELECT * FROM item
WHERE price > (SELECT AVG(price) FROM…
Boohz12
- 19
- 5
0
votes
3 answers
Match Id from one table with name from another and null values - mimer sql
I want to bring a column from another table that matches my id from the current table.
I've done this query:
SELECT dept, SUM(quantity) as TotalQuantity
FROM sale
GROUP BY dept
ORDER BY TotalQuantity;
Which gives me a total of items sold of a…
Boohz12
- 19
- 5
-1
votes
1 answer
Deleted specific id from different tables
I would like to delete specific IDs from different tables to remove these values.
My formatted question is this:
Earthquake! California sinks into the ocean, and all our suppliers in California disappear under the water. Write a query to delete…
Boohz12
- 19
- 5