Does anybody know what is the limit for the number of values one can have in a list of expressions (to test for a match) for the IN clause?
I'm new to postgresql. Can anyone suggest the reason and solution to this error? However it works if I select an extra sum(s.length) but i don't won't this in m
I'm working in a centralized monitoring system on Windows 2008 R2, I have installed a PostgreSQL 9.3 to use psql from the command line. When I try to access to
I have my sql query which displays fields using "where" from a variable. I have my variable passed from a function string empCode which value is "!\\(" Here's
I'm working with MariaDB. when I try to show some result don't show me nothing. select if(fecha is null,'hello','bye') dat from table I'm trying to
I am working on an app that is providing a way for an user to define a SQL query and run it against the database. The only purpose of the query is to create a d
I am working with healthcare data that comes from a table that only has one column for procedure code billed, but multiple lines of transactions for each claim
I need to write a query that returns the latest message in a conversation between two users. I've included the schema and my (failed) attempts in this fiddle: h
i need to sum this varchar values. time 1 = '13:06' time 2 = '18:59' time 3 = '14:49' i tryed this. SELECT convert( char(8), dateadd( secon
I am trying to save a python list to an SQL table in a PickleType column which is defined in the class object as text = Column(PickleType). When I try to commit
I have local and a linked server tables in SSMS local [Arc].[dbo].[Record] linked server SQLSERVR.[ArcReport].[dbo].[RecordRemote] when I query select * from [
I am very confused to understand the difference between sparse index and dense index. Can you explain the difference between them ?
I want to query the list of CITY names from the table STATION(id, city, longitude, latitude) which have vowels as both their first and last characters. The resu
I have two string columns a and b in a table foo. select a, b from foo returns values a and b. However, concatenation of a and b does not work. I tried : sel
I am executing this query with core cron by custom Wordpress plugin: // MAKE SQL CALL $SQL = "SELECT ".$wpdb->prefix."postmeta.post_id FROM ".$wpdb->
I have a working query that is grouping data by hardware model and a result, but the problem is there are many "results". I have tried to reduce that down to "
I have this query: SELECT * FROM (SELECT a.id AS id, a.user_id AS user_id, aa.power * a.amount AS total_power, a.group_number A
I'd like to take two columns (latitude and longitude) and create a single column with the combined information. The final goal is (a) see if I can gather useful
I have the following query: select b.month_date,total_signups,active_users from ( SELECT date_trunc('month',confirmed_at) as month_date , count(
I developed typeorm querybuilder. For the purpose of debugging, I'd like to show the generated SQL query. I tested printSql() method, but it didn't show any SQL