Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 17

Counting rows from a subquery

Simple: I would like to count the number of rows from the sub-query. Note that status is whether the host is online or not.Bad codeSELECT COUNT(ip_address) FROM `ports` (...

Asked on 11/14/2021 by rwcommand

3 answer

Get Updated_At for any change in row on Sybase?

I am working with a Sybase SQL Anywhere table that has horrible tracking of changes. I have a windows service that queries multiple tables every 5 minutes looking for changes,...

Asked on 11/14/2021

1 answer

Having a subquery somehow do the same group by as the outer query

i'm pretty decent with SQL but it's not my main experience of expertise. A colleague asked me a stumper of a question the other day. I was wondering if you...

Asked on 11/14/2021 by Mag Musik

1 answer

Postgres looped table (start sequence from 1 and rewrite old rows)

I want table to contain logs and be looped, so when it came to last key in sequence it will start over from one and will rewrite old logs. I...

Asked on 11/14/2021 by ZiiMakc

1 answer

Postgres index not being used

Postgres 9.6.8, a table with 6GB including a jsonb field that is up to 15MB. The query planner is not using any indices btree or gin when querying that...

Asked on 11/14/2021

1 answer

How to get the registers in the highest time of period

I have 2 tables all with relations and I want to get the contracts in the highest time of period in order to do a historical report whether if the...

Asked on 11/14/2021 by Wilson Eduardo Millan Vargas

1 answer

Mix ;WITH NAMESPACES and schema collections?

I'm getting these xml files from a vendor, and it's a wrapper of NITF (news) schema and the http://www.xmlnews.org/namespaces/meta# news metadata schema (from Space 1999!) Unfortunately, they...

Asked on 11/14/2021 by user1664043

1 answer

Find timestamp for highest number of concurrent users by date

I have a table including these columns: Sample data:concurrent_users concurrent_timestamp concurrent_date3 ...

Asked on 11/14/2021 by Sharvari

4 answer

To generate a script to drop or map the orphan users in a SQL Server Instance

I am very new to SQL Server. I have a script which find the orphan users in all the databases and generate the script to either drop or map the...

Asked on 11/13/2021 by Saravana Kumar

3 answer

MariaDB tmpdir & table copy operations

I have a Linux server & MariaDB v10.0.33, where tmpdir is tmpfs (ram), for fast temporary table access; tmpfs is obviously limited in size. MariaDB seems to use the same...

Asked on 11/11/2021 by user120053

1 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 17)

Ask a Question