Facing issue in auto generation of serial number. How can i use row_number() in proper manner or is there any alternative to achieve the expected results? Note: I want to write query without using CASE. Current Results: Expected Results: Answer You can try to use ROW_NUMBER window function in a subquery, then…
Tag: sql
SQL comparing column changes the last X hours
I have a table containing log entries that looks like this: id | name | level | timestamp 5 | ironman | 35 | 2019-01-06 11:37:40 6 | ironman | 35 | 2019-01-06 11:38:40 7 | ironman |…
SQL Anywhere error – Function or column reference to ‘Fraction’ must also appear in a GROUP BY
I have this simple SQL SELECT that summarizes by ProductID but I get this “must appear” error. SQL requires me to put column Fraction into GROUP BY clause which I do not need. I just need to summarize by ProductID. How do I build correct SQL statement here? Thanks. Answer You need to use aggregate…
how to do a few queries MYSQL
this is my homework, i am searching. total 17 question.I couldn’t make 5 questions but i am trying, trying.. list the number of books each student reads. But next to those who do not read the book …
between date inteval mysql not showing today
my query: SELECT p.idprd, p.nmprd, pe.idprd, pe.stockjual, pe.stockkeluar, pe.tothrgjual, pe.tgljual FROM tbproduk AS p INNER JOIN ( SELECT …
Multiple COALESCE in GROUP_CONCAT – is showing value if only first column isn’t null
Two table’s purchase and sales ‘s column date column has been concatenated as date row. GROUP_CONCAT(purchase.date,’,’,sales.date) AS date But both of them can be blank, according to data input. So …
Is it possible to select multiple tables with different quantity attributes?
Note: I looked in this forum and could not find the solution I’m looking for. These are the tables I created: library: name, registry book: date, author, code Question 1: Is it possible to …
How To Convert Linq To Sql?
I want write code for table, I know in SQL Server, but I don’t know Linq or EF. SQL Server code: SELECT * FROM Driver WHERE id IN (SELECT Driver FROM Drive_Car WHERE …
a little bit confusing about a syntax on my databases MySQL
i try to check my databases with : I also try to check my databases on : Why are the results different with SHOW DATABASES; and SELECT Db FROM mysql.db; ? Can i update my databases on mysql.db tables ?? Thanks in advance. Answer mysql.db id an internal system table, hence it is hard to find official documenta…
SQL: How to use REPLACE INTO with two tables and only if specific values match?
I have two tables with the same columns and ids. Table 1 contains the main records. Table 2 contains updated records and new records. Table 1: ID | STATUS | CONTENT | etc.. …