I have a database of daily tables (with prefixes formatted as yyyymmdd) with customers info, and I need to get a 90 day timeline of 90 day ARPUs (average revenu
Let be the number of CITY entries in STATION, and let be the number of distinct CITY names in STATION; query the value of from STATION. In other words, find
I am a beginner making use of a Roomdatabase. Mostly using it to load in and pass items between tables using simple relationships. package com.example.allin
I've a status table and I want to fetch the latest details. Slno | ID | Status | date 1 | 1 | Pass | 15-06-2015 11:11:00 - this is inserted first 2
Does any one know how to transpose rows to columns in PostgreSQL? For example I have the following table:- Period T1 T2 D
I have a very simple query that results in two rows: SELECT DISTINCT id, trunc(start_date) start_date FROM example.table WHERE ID = 1 This results in the fol
I have a table where the datetime is stored as varchar but represents the EPOCH time (e.g. 1556895150). How can I get that value to be recognized as a timestamp
I have database size is more than 125 GB . and every 1 hour the database is not respond . the message is every time say (The transaction log for database MESP_2
I have the following data set: which is daily sum. Based on this, how do i get last 7 days sum, 14 days sum and 21 days for each row in new columns. I have trie
I need to run a query as cronjob and it is too slow to perform. It sums a value from a view table (data_time_series) for each pair of aks and ii and inserts a r
=# select row(0, 1) ; row ------- (0,1) (1 row) How to get 0 within the same query? I figured the below sort of working but is there any simple way? =# se
say I have 3 values, Bill, Steve, Jack. and I want to randomly update a table with those values, eg Update contacts set firstname = ('Bill','Steve','Jack') whe
Consider a table defined by CREATE TABLE Example (id INTEGER) and an INSERT statement for adding tuples to Example, having a single quote in a SQL comment:
I am working on android project. In my project I have a 'DatabaseFood .sql 'file(initially it was a .csv file), it looks like this BEGIN TRANSACTION; CREATE TA
Let's say I have the following range in Excel named MyRange: This isn't a table by any means, it's more a collection of Variant values entered into cells. Exce
I am using SQL Server 2008. I would like to give users possibility to copy files. Is it possible without using XP_CMDSHELL procedure? Cause i should not change
Suppose, following the AWS docs I'd like to use an unload command like unload ( 'SELECT * FROM table_name WHERE day = '2019-01-01' ') to 's3://bucket_name/
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. select distinct(city) from station where c
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplic
i need to make an sql transaction, that only commits the insert if the one date is greater than the other, and rolls back if else.. this is what i have: START