The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

Combine Access Row Text According to the Column Valua

I have a table like below where I want the query output to be like the right expected table. I want to combine the texts in "Partner" column according to the "Location" column. Picture:Table and ...
0
votes
1answer
25 views

relation tableName does not exist - PostgreSQL

I have a database named mimic on my postgres DB . I'm trying to execute this command : select hadm_id from admission_ids where hadm_id in (select distinct on (subject_id) hadm_id from (select * from ...
0
votes
1answer
88 views

Add Watermark to the bottom right

I want to add a watermark at the bottom right with query given below, also shown in this image: My command is: String[] command121 = { "-y", "-i",inputPath_audio.mp3, "-loop", "1", "-i", ...
0
votes
2answers
35 views

Multiply several columns by Paramater

I have a set of budgeted columns - Jan, Feb, Mar, etc will sales values in a Foreign currency. I want to multiply all monthly columns by a FX rate enter via a Parameter. It this possible? I know I ...
0
votes
1answer
80 views

javascript in mongoshell

I want to make a join query in mongodb. Mongo doesn't have any join operator so i have to split the query in two parts. first: var a = db.articoli.find({_id: 4010}, {ordini:1}); var b = a[0].ordini; ...
0
votes
0answers
4 views

Azure Queries - How can I create a query that is flat list to return all features under an Epic?

I'm trying to create a query in Azure that I can use charting with, which means that it has to be a flat list query. I can't seem to find a method to return for example all features under this Epic ...
0
votes
0answers
66 views

How to write influxdb query that uses multi-value variables in grafana

I have a variable "customer" in my grafana dashboard. It has the multi-value option enabled. Now I want to use this variable in my query. When multi-value was not enabled my query looked like this: ...
2
votes
1answer
50 views

How to execute remote mysql query after granting permission?

I am trying to execute mysql query from another ubuntu system. I have granted permission to user using GRANT from 192.168.64.9 GRANT ALL ON . to 'user'@'192.168.64.11' WITH GRANT OPTION; and then ...
0
votes
0answers
50 views

Prometheus query failure in Grafana

Here is error after running the Query Inspector from within Grafana to Prometheus datasource. Object data:"" status:502 statusText:"Bad Gateway" xhrStatus:"complete" request:Object method:"GET" ...
0
votes
0answers
28 views

How to template InfluxDB query in Grafana

I have the following: kinda targeted setup (sorry, no image with rep. < 10) Sensors writing data points with their respective name. As you see there are two queries differeing in name=XXX. So I ...
1
vote
1answer
46 views

WMI query to detect if Windows Home or Pro

I am using MDT to deploy my computers and want to have it run a second task sequence when it hits the custom tasks stage. One thing is that i want to have Both Windows Home and Pro editions in the ...
0
votes
1answer
8 views

How would I create a LEFT JOIN SQL query in Access using the Query Wizard?

Is this even possible? I always end up with INNER JOIN after viewing the SQL that the wizard provides. I know how to write the query myself. I'm just trying to figure out if I should be selecting ...
0
votes
0answers
27 views

Does phpMyAdmin 4.7.6 have ability to save SQL queries

I've recently upgraded to latest version of phpMyAdmin and it appears the ability to save queries has disappeared. Maybe there is a setting I need to change to get the dropdown and ability to save the ...
0
votes
1answer
23 views

ACCESS Query does not find all records

I am testing a simple database of patient recorded vitals. I am trying to do a query of those patients with a BGL >250 within the last week. I have put in test data to trigger return but not all ...
0
votes
0answers
31 views

Dialect class not found: org.hibernate.dialect.ExtendedSQLServerDialect

I'm using a BI suite called Knowage (I hope there are some users here). When i try to build a Meta-Model i get the following error: Error while initializing Qbe interface java.lang.RuntimeException: ...
0
votes
1answer
287 views

How to get query command on Windows 10

I have a Windows 10 computer on which I need to see what users are logged in via an SSH connection (which is the command prompt). I figured I could run query user on the machine, but the query command ...
0
votes
1answer
156 views

Queries run slow after updating database from SQL 2008 r2 to 2014

I've changed my database edition from 2008 r2 SQL server express to 2014 enterprise edition. The point is, queries run like 3 times slower than the old server. I'm testing on the same data and I've ...
0
votes
0answers
18 views

I have a query of 5 tables and about 120,000 rows of outputs. How can I display them in the grid for high performance? sqlserver optimize

I have a query of 5 tables and about 120,000 rows of outputs. How can I display them in the grid for high performance? microsoft sqlserver microsoft visual studio
0
votes
0answers
27 views

Redash Dashboard - time required to execute query

I want to find out how much time did it take to execute mysql query on Redash. It shows a counter in minutes:seconds format when i execute query but it disappears as soon as result of query is ...
0
votes
0answers
33 views

Get HTML table from a website based on a hyperlink in a cell

The following code gets me my HTML table just fine. However I need to use a dynamic URL based on a Cell reference in the active sheet - Cell("A27"). Below is the code I have been using: Sub ...
0
votes
1answer
20 views

SQL Server 2012

I am new to SQL with no training what so ever and what little I do know I taught myself so please be gentle with me. I have a table that has 4 columns. I will call them customers, customer code, ...
0
votes
0answers
17 views

SUB query execution strategy in Oracle on a table with huge number of tuple

We have a table with good amount of rows(150,000+) and each row has to be selected based on a SUB query on another table. The values return by SUB query is independent to the column in this table. So, ...
0
votes
0answers
15 views

Software BaseX error

I'm practicing with XQuery and for that I'm using the BaseX software. Now I have a problem. It turns out that when I want to open an XML file it redirects me to a route that I had previously used, and ...
0
votes
1answer
38 views

SQL Server's Maximum Workspace Memory decreases over time - only instance restart to increase it

This is an SQL Server 2016 CU2 instance with 15 GB configured as maximum RAM usage. MDOP is at 4. The databases in this instance are very sporadically queried by users and this is a read-only ...
0
votes
0answers
74 views

Querying Offline Files available disk usage

Looking for a way to query the Offline Files "available" disk usage (Windows 10). The value I want to query is displayed in the Offline Files GUI on the Disk Usage tab. The value is not based on ...
0
votes
2answers
82 views

Access SQL Subquery to find a value from the previous year record (Max/Top minus 1)

All the advice I was able to locate doesn't seem to get at this (I am also trying to avoid a DLookup in the Table itself): The table: Table has client records including a Year field, an ...
0
votes
0answers
38 views

Vlookup query with IF, AND and possibly any other commands

I've prepared a table in which I need to have a vlookup function to manage multiple criteria based on data in corresponding cells & sheets. I need help to implement the following rules: SHEET ...
0
votes
0answers
41 views

Display result from mysql with datetime intervals

How to display results with time intervals, for example 15 minutes? If I perform this sql as below: SELECT datetime, cpuidle as 'CPUTotal' FROM tablename where id = 1231 and datetime >= '2019-01-...
0
votes
0answers
34 views

MongoDB shell version v4.0.5 : Very Slow Query

MongoDB shell version v4.0.5 : Very Slow Query | Taking time in fetching | Data Size : 2-3 Million documents in a collection and there are around 13-15 such collections. System Conf: Architecture: ...
1
vote
0answers
176 views

DNS queries “DomainServer.dom.local.dev.null” by QNAP NAS

We encounter strange DNS queries intiated by a QNAP NAS: DomainServer.dom.local.dev.null DomainServer.dom.local (name is obfuscated here) is the valid name of the domain controller. But the NAS adds ...
-1
votes
1answer
82 views

Excel: New Powerquery from Web (csv) doesnt work

I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data. ...
0
votes
0answers
36 views

Is it possible to change/save default “Web Query Options” in Excel

Does anyone know is it possible to save or change the "Web Query Options" default settings. I want that "Disable date recognition" is always checked. Any solution is welcome, even if it should be ...
0
votes
0answers
20 views

How to create readonly table from raw data

If I have a large table of data, essentially like a database, can I create another sheet or range that is a filtered subset of the full dataset? If so, will it stay up to date when the main table ...
0
votes
1answer
412 views

Run a mySQL Query With a Parameter from Excel - Multiple Rows

I was able to adapt this link for my project, but I am looking for a way to duplicate for multiple rows. Here is my query: SELECT data_0.InvoiceNumber, data_0.CustomerNumber, data_0....
0
votes
2answers
1k views

DNS and understanding root servers

Firstly, is this explanation on how DNS works right? When we visit a site, say (www.example.com),we are doing a lookup to convert the domain name to an i.p address. So, our computer first looks at ...
1
vote
1answer
96 views

How come this query shows the same address for non-authoritative answers and authoritative answers?

So, if i query slash16.org: nslookup -type=ns slash16.org Non-authoritative answer: slash16.org nameserver = ns-686.awsdns-21.net. slash16.org nameserver = ns-1989.awsdns-56.co.uk. slash16.org ...
0
votes
1answer
37 views

Perform a Windows 7 search & display files with identical names but different integer value at end of each?

Lets say I have the files: doc01, doc02, doc03, doc04...doc64 Is there a query I can enter in a normal windows 7 search box, to pull up all these ten files? Also note they they usually have the same ...
1
vote
2answers
127 views

Excel: show list of values based on query in range

I have a table like this: a | tomato b | pear c | tomato d | pear I would like to create a formula that lets me select which rows contain tomato and which ones contain pear. ...
0
votes
0answers
36 views

Pivot source with SQL vs. Table source with SQL and then Pivot based on the table

If I want to pull SQL data into a Pivot table, what will be quicker and more efficient? To have the data pulled into a regular table (which I want to present anyway) and then create the Pivot based ...
0
votes
1answer
102 views

Change the perspective of data in excel

I have the following scenario: I have records of students in a table. Each student has: Name, Email, Gender, Id, Country Additionally, each student has Choice1, Choice1Feature1, Choice1Feature2 ...
0
votes
1answer
199 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1answer
19 views

Query that needs input from two different records

I have a "timecard" table. A few typical entries might look like ID task date start time 1 proj_XDFR 4/5/18 8:30 2 proj_PEIRN 4/5/18 9:45 3 proj_ERU54 ...
1
vote
1answer
77 views

Is Distinct adding any value or doing anything in this Query?

Assuming the Users.Id field is unique auto incremented MY MAIN QUESTION: Is "Distinct", in this query, doing anything, is it completely pointless having it in this specific query? SELECT DISTINCT ...
0
votes
1answer
396 views

MS Access 2016 Record count with subquery count with percent result

I have a query that counts the number of records in a table that contains a number of repair tickets, and the result is the number of repair tickets by company that have been completed. Example; ...
1
vote
0answers
54 views

Can I save 'Outlining in my MS SQL Query

When writing a query, I will often use Cross Apply, or multiple sub queries. To make the query easy to read I realized you can outline parts of the query, and then hide them. Using: Edit -> ...
1
vote
0answers
38 views

Adding external query from website into existing table?

Been trying to figure this out for a while, I'm not good enough at excel to see where the existing information is accessing the query. I have no idea how it works but the post made it seem like all ...
0
votes
1answer
63 views

Using MS Acess 2016 to remove specifc fields of a record while still displaying the entire dataset within a query

I am looking to query a dataset of mine in MS Access 2016 where only specific strings are included within the query's output (please take a look at the included image). I am looking to include all ...
1
vote
1answer
3k views

How to get data from web using Cell values to assemble URL to pull from? Getting Data from web using cell references

How to get data from web using Cell values to assemble URL to pull from? How do I go about using cell references to assemble a URL that excel can use to get data from the web with? Basically I'm ...
1
vote
2answers
56 views

Excel 2016 - Data from Web - 100+ sheets - Combine into a single sheet

I am trying to pull data for each Sector at http://www.moneycontrol.com/stocks/marketstats/sec_performance/bse/abrasives.html, into Excel 2016 using "Data", "From Web" - There are a total of 112 ...
1
vote
1answer
171 views

Attempting to transpose two column table in excel using first column to group values in second column

I have a two column table in Microsoft Excel 2016 that simply lists a expense category in first column and expense amount in second column. expense category are not unique and will repeat multiple ...