I am trying to get all customers with their latest payment transaction, including customers without any transaction: SELECT c.customer_id, c.phone_number, c.email , p.transaction_no, p.amount, p.transaciton_datetime FROM tbl_customers c LEFT JOIN ( SELECT customer_id, transaction_no, amount, transaciton_datetime FROM tbl_payment_transactions ORDER BY…
Fiddle i created: http://sqlfiddle.com/#!9/e22eb6/2 Data for each tables I tried below query but its only showing result which particular user has authority/permission assigned on him, i want all records(permission avaialble) in authority_master table along with matched one. SELECT U.first_name, UR.authority_id…
i'm quite new to postgressql, so i have a table called public.dim_products with a column called weight_kg what i would like to do is given some weight in the weight ranges below to set up a new column called weight_class…
I have the following table: car score description Opel 30 43 Volvo 500 434 Kia 50 3 Toyota 4 4 Mazda 5000 4 How I can delete all the content of table column score without changing the table structure? Expected…
I have data with start date and end date (Say 20th Feb 2018 to 20th Feb 2020), I want to find out the total days in every year inside this range. For example: 2018 - x days , 2019 -…
I am using DuckDB and want to process some time-series data that has the following format: ┌─────────────────────┬─────────┬─────────┬─────────┬─────────┬────────┬────────────┐ │ Timestamps │ Open │ High │ Low │ Close │ Volume │ CustomDate │ │ timestamp │ double │ double │ double…
Noob question. Despite following the official PostgreSQL syntax I cannot insert multiple rows into a table. It always ends up adding all values to the first row. I first created a table like this: create table "DBSTest".Test (column1 varchar, column2…
There is my table look like id name deduction amount 01 teat Home Rent 1000 01 test GPF 500 i want show my data in deduction report like below table id name home_rent gpf 01 teat 1000 500 mysql code…
I have a SQL table that looks something like this: Date Object_ID Category Direction 0 2011-02-02 0H 1234 JKL/987 A N 1 2011-02-02 0H 4321 BNM/987 A N 2 2011-02-02 0H 5678+ JKL/987 A N 3 2011-02-02 0H 8765 BNM/987…
I hope someone can help with this! I've used the following query to count the distinct values in column2 and column3 and filter the results: SELECT column1, COUNT(DISTINCT(column2)), COUNT(DISTINCT(column3)) FROM table1 GROUP BY column1 HAVING COUNT(DISTINCT(column2)) > 1 OR COUNT(DISTINCT(column3))…