I am having three columns,- and / should be used as separator result should come in new column(File Index-sub Index/Year),if sub index is blank then result should be (File Index/Year). SELECT [ …
SQL+Fetch rows with latest date+Case when row_number()+Duplicates
I have a table with fields(id, date, product) with below sample data id date Product current_Flag Expected_flag 14834 2019-01-03 00:00:00 A 1 1 14834 2019-01-31 00:00:00 B 0 0 …
Struggling with correlated subqueries in SQL
I have a database about old cars, their owners, events and the attendants of those events as such: Image of tables used : PK: Primary Key FK: Foreign Key Now I need to get the amount of different …
Adding missing date rows to a BigQuery Table
I have a table where 1 of the rows is an integer that represents the rows time. Problem is the table isn’t full, there are missing timestamps. I would like to fill missing values such that every 10 …
how to extract date from string in sql oracle 9i
I have column Explanation (VARCHAR2) in table: No| Explanation 1 | Shipment of cabbage by agreement 29.04.2019 TAX Free 2 | Payment for screws (01.04.19) Tax: 13.55 % 3 | For reserch by deal …
How to calculate table values dynamically and find Min and Max target from parameter in SQL Server
I want to calculate table values dynamically and find Min and Max target from parameter I have the following target table with data: Name Quarter Method MethodID GivenTarget Percentage …
Service that does advanced queries on a data set, and automatically returns relevant updated results every time new data is added to the set?
I’m looking for a cloud service that can do advanced statistics calculations on a large amount of votes submitted by users, in “real time”. In our app, users can submit different kind of votes like …
How to adress variable Columns of SQL query with TWIG
I am trying to address a specific column of a SQL query depending on the value of another row from the query. The result I am getting from the SQL query is something like this: Number | Value1 | …
Unselect all records of same customer if a condition met
I have two data tables: Table KHACHHANG: MAKH TENKH DIACHI DT EMAIL —————————————————————————- KH01 NGUYEN THI BE …
How to get totals from another table
I have table 1 of Cars and table 2 Trips. Below are the two tables fields –CARS table car_id (PK), car_model, car_miles –TRIPS table trip_id (PK), trip_destination, trip_date, trip_miles, car_id (…