I need to use ORDER BY in a query that uses UNION. The query returns the following: CRN Inv_1 Inv_2 GBP -100 -100 GBP -400 -400 GBP -500 -500 GBP -700 -700 GBP -800 -800 GBP -10000 -10000 GBP 100 100 GBP 400 400 GBP 500 500 GBP 700 700 GBP 800 800 GBP 10000 10000 Expected Output: CRN Inv_1
Tag: sql
Starting and Ending a row-count based on values in another column
There is a need to monitor the performance of a warehouse of goods. Please refer to the table containing data for one warehouse below: WK_NO: Week number; Problem: Problem faced on that particular week. Empty cells are NULLs. I need to create the 3rd column: Weeks on list: A column indicating the number of we…
Error => #1242 – Subquery returns more than 1 row
I am selecting order data from my orders table with that I also need the order product’s count which contains a specific word Account TopUp 200, Account TopUp 500, Account TopUp 1000, The order contain multiple product means one order contains both(Account TopUp 200, Account TopUp 500) and other product…
MySQL Where condition with CASE
Here i want like if cksp.status is not null then condition should be cksp.is_include_in_pipeline = 1 ELSE ignore the where condition Answer That logic should be similar to:
Is there any way to use CASE in WHERE clause in Oracle?
I have the following data in DB which supposed to be a date but in number format: date_col: 20200130.95656 20200910.85213 0 20220101.55412 0 0 20220730.85626 Now I need to format the dates to mm/dd/yyyy so I used the following command in oracle: to output it like this 07/30/22. But the problem I still need to…
How to write an array literal in SQL?
Is it possible to use an array literal in Oracle, such as: Or: Or what’s the simplest (i.e., possible not in PL/SQL?) way to do this? Answer if you wanta flexible list, y an use a type like this ID | INTLIST -: | :—— ID | COLUMN_VALUE -: | ———–: 1 | 1 1 | 2 1 | 3
Oracle missing FROM clause
Is it possible to create a CTE without a FROM, and if not isn’t that the whole point of a CTE in the first place? It seems a quick-fix for this is just adding FROM DUAL whenever needed. Is that what’s supposed to be done? Answer Yes, that’s exactly what dual is supposed to be used for. Selec…
Create database user using stored procedure MS SQL [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 6 months ago. Improve this question I have an idea to create database user (account with username and passwor…
sql sales data grouped by year in separate columns in postgresql
I have two input tables: analysis (an_id, an_name, an_cost, an_price, an_group) orders (ord_id, ord_datetime, ord_an) # orders of analysis (sales) For every analysis_id I need to show the amount of orders for years 2020 and 2019. Expected output: an year2019 year2020 1 32 41 2 29 28 3 42 37 4 26 35 5 32 34 lo…
ODBC – Exclude weekends in SQL
I currently have this SELECT statement which allows me to get yesterday’s date: However, when the day is Monday, I need the result to return a value date for Friday and not Sunday. When the day is Tuesday to Friday, it would be the SELECT Statement mentioned above. What would be the right code line to a…