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
What is the correct way to take user input in Power Automate Desktop and pass that input as a parameter/variable in an SQL query. For example, if user enters a
I use https://github.com/mysqljs/mysql.git library. I have a mysql db query architecture in which I can not modify the SQL query file one by one to escape each
When I used H2 database the database files are stored at C:\Users\MyName\TestDataBase.db directory. The H2 path is jdbc:h2:~/TestDataBase. This is default H2 da
i have a dynamic list. list=['a','b','c','d' ..... ] so length may change i want to compare these list values in a query select * from student where name i