Questions tagged [sql]
Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used. If your question relates solely to a specific DBMS (uses specific extensions/features), use that DBMS's tag instead. Answers to questions tagged with SQL should use ISO/IEC standard SQL.
47
questions
0
votes
0
answers
7
views
Sql Developer: The network adapter could not establish the connection
I am not able to connect my Oracle Database to SQL Developer.
I've installed Oracle19c and Sqldeveloper, SQL Plus works fine, but i am not able to connect it to Sql Developer, i am getting the vendor ...
- 1
0
votes
0
answers
21
views
How does SQL Server allow multiple of the same alias in the same SELECT statement?
I was doing some queries with Dapper and came across a use case where I needed to return different columns using the same alias to be able to map into different objects with the same property name e.g....
- 1,113
0
votes
0
answers
16
views
Converting basic update logic from a table to a view in Snowflake
I'm working on converting something that's currently in a table in snowflake into a view. One of the big issues I've run into is that the code I was provided to build the table uses the SQL UPDATE ...
0
votes
0
answers
21
views
I need to update a row in a table after the use of a view in MySQLWorkbench
It's been a while since i used MySQLWorkbench to make queries and i'm kinda lost here.
I want to update a row in a table named last_export that refers the last time a specific app had access to the ...
0
votes
0
answers
23
views
Caching a tableresult in psql for further queries
I was wondering if my thoughtprocess is somewhat reasonable or if there is a better way and what tooling to use.
Setting: I got a filter with fuzzy search and everything, this is the most "...
- 1,337
-1
votes
1
answer
38
views
how to convert an sql view to table
I have a view and its taking longer time to execute so i need to write simple query to rather than view.
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `...
0
votes
1
answer
28
views
why this SQL statement doesn't work for finding the differences between two tables based on some key fields
My Oracle version is 11g and I have two tables , their structures are like
CREATE TABLE "WP_CLI_CARD_JF" (
"COM_MD_CODE" VARCHAR2(6 BYTE) NOT NULL,
"COM_DB_ID" ...
1
vote
1
answer
33
views
Microsoft Access SQL
I am looking for a solution to fill fields in an Access DB SQL statement.
Any suggestions?
Example of the dataset attached:
Goal:
I am looking for a solution to fill fields in an Access DB SQl ...
- 11
1
vote
0
answers
22
views
use SQL query via Power query to inquiry a different excel spreadsheet
I have an excel spreaadsheet (ExcelData.xlsx) that contains a table named "tblTransactions".
I would like to understand if it is possible (and if so, how) to use a SQL query (through Power ...
- 11
1
vote
0
answers
27
views
Create query statement from a resultset of a previous query
This is the original table: "multiactualusetest"
TAXDECNUM
ACTUALUSE
TAXABLE
MARKETVALUE
ASSESSEDVALUE
G-508659
S
Y
182000
0
G-508659
C
Y
166600
16660
G-508659
A
Y
9768
3910
G-508659
R
...
- 11
0
votes
0
answers
41
views
Getting "Illegal Argument: Invalid UUID string" error when using UUID as primary key in Oracle NoSQL
I am using OCI Functions.
I'm working with Oracle NoSQL and encountering an issue when using UUID as a primary key. Whenever I attempt to run a query or update statement using a UUID as the primary ...
- 21
0
votes
1
answer
18
views
Athena extract value from nested json with dynamic key
I have following json
{"GrossORNet":"Net","Term":"Monthly","Tier":{"All":{"1":{"Max":"100000","Min":&...
- 4,518
0
votes
0
answers
41
views
Why do some of my SQL explicit pass through queries run in SQL Server but not in SAS EG?
As I understand, explicit pass through queries are sent verbatim to the SQL server from SAS.
I have something like:
proc sql;
connect to odbc(dsn = dbname);
execute by odbc(
/* some preceding code ...
- 1
0
votes
1
answer
19
views
How to use the right index to optimize a database to get rid of unwanted hash matches?
lately we have been learning about database managind through microsoft sql server management studio and were learning of how to use the index function to optimize a consult and data management, and a ...
- 1
0
votes
0
answers
23
views
How can I grant view definition to a user in SQL using inserts?
I want to grant view definition permission to a user. I don't want to use
GRANT VIEW DEFINITION on <db> TO <user>
as I need to grant permission, perform some tasks, and then revoke the ...
- 9