Recent questions tagged SQL

0 votes

560 views

1 answer

sql - ssis best practice to load N tables from Source to Target Server

I need to load N (around 50) tables from a Source DB to a Target one. Each table is different from the ... to address such a scenario? Mario See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

603 views

1 answer

sql - getting "comma-separated list near 'xx.yy' invalid" with dbms_utility.comma_to_table

I have string like this: str:='ac_Abc.88,ac_Abc.99,ac_Abc.77'. I need to get first element after splitting ... suggest how can i solve this. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

560 views

1 answer

sql - Select statement to return parent and infinite children

Give the table structure, as something like: ID ParentID Name 1 NULL A root 2 NULL Another root 3 1 Child of ... so, how would I accomplish it? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

468 views

1 answer

sql - MySQL: Computed Column

I'm just started using SQL and ran into a problem. In my database, I presently have two tables, Cinemas ... computed column (if even possible). See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

515 views

1 answer

sql - How to join two recordset created from two different data source in excel vba

My Scenario is - I have one set of data in .xls file and another set of data in oracle data base table. I want ... it but vba How I can do this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

507 views

1 answer

sql - MYSQL Select One Random record from each Category

I have a database with an Items table that looks something like this: id name category (int) There are ... never done something like this. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

533 views

1 answer

sql - Get the name of a row's source table when querying the parent it inherits from

I have a Postgres database with several tables that inherit from one other. I can SELECT from the parent table ... the results ahead of time. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

491 views

1 answer

sql server 2005 - SQL Sorting and hyphens

Is there a way to easily sort in SQL Server 2005 while ignoring hyphens in a string field? Currently I have ... to ignore the hypen in strings. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

826 views

1 answer

sql - scope_identity vs ident_current

After much research I am a little confused by which identity tracker I should use in sql. From what I understand ... there a flaw in my logic? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

767 views

1 answer

sql server 2008 r2 - Optional multi-valued parameters in SSRS

I have 3 multivalued parameters in my report.Out of them 2 are optional. Is there any way to get the ... point me in the right direction? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

551 views

1 answer

sql - MySQL for replace with wildcard

I'm trying to write a SQL update to replace a specific xml node with a new string: UPDATE table SET ... missing for this type of request? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

594 views

1 answer

sql - Postgres function returning table not returning data in columns

I have a Postgres function which is returning a table: CREATE OR REPLACE FUNCTION testFunction() RETURNS TABLE(a ... return data as columns? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

626 views

1 answer

sql - MySQL: "The SELECT would examine more than MAX_JOIN_SIZE rows"

I am using PHP and MySQL. In my program there is a select query involving joins. When I run it on localhost it ... okay How can I correct this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

514 views

1 answer

sql - Combine multiple SELECT statements

I've used Excel to generate numerous SELECT statements from a list of the schema names from a database with a ... in a more efficient way? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

480 views

1 answer

sql - What is causing Foreign Key Mismatch error?

I have an sqlite database structured as follows: CREATE TABLE IF NOT EXISTS Patient ( PatientId INTEGER PRIMARY KEY ... what I am doing wrong. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

405 views

1 answer

sql - Get values from first and last row per group

I'm new to Postgres, coming from MySQL and hoping that one of y'all would be able to help me out. I ... wondering what I'm doing wrong here? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

460 views

1 answer

sql server - Create nested JSON arrays using FOR JSON PATH

I need to create a JSON output from a query that uses inner join between two tables with a one to many relationship. ... ] } How can I do this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

411 views

1 answer

sql - Can I get better performance using a JOIN or using EXISTS?

I have two tables Institutions and Results and I want to see if there are any results for institutions that way ... EXISTS? Thank you, -Nimesh See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

503 views

1 answer

sql - The network adapter could not establish the connection - Oracle 11g

I wrote a servlet program and I want it to connect to my Oracle database but its giving me an error. I ... be appreciated. Thanks in advance. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

594 views

1 answer

sql - Hive - Unpivot functionality in hive

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

433 views

1 answer

sql - Functions with variable number of input parameters

I'm creating a stored procedure (function) in a PostgreSQL DB, which updates a table depending on its input ... different ones for each purpose? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

390 views

1 answer

sql - Opinions on sensor / reading / alert database design

I've asked a few questions lately regarding database design, probably too many ;-) However I beleive I'm ... an elegant solution to this! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

402 views

1 answer

sql - MySql. How to use Self Join

I need to use Self Join on this table. +------------+------+--------+ | Country | Rank | ... am getting only Turkey. What am I doing wrong? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

612 views

1 answer

sql server 2008 - T-SQL strip all non-alpha and non-numeric characters

Is there a smarter way to remove all special characters rather than having a series of about 15 ... as CustomerNameStripped from Customer See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

499 views

1 answer

sql server - SQL Group BY, Top N Items for each Group

I have a SQL Query which gets gets top 5 sold items at a given store. SELECT TOP 5 S.UPCCode, SUM( ... a single query. Thanks in advance. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

906 views

1 answer

sql - How to measure the execution time of a query on Spark

I need to measure the execution time of query on Apache spark (Bluemix). What I tried: import time startTimeQuery = ... to when I see the table. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

518 views

1 answer

sql server - Include missing months in Group By query

I think I have a tough one here... :( I am trying to get an order count by month, even when zero. ... grouping is causing that not to work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

659 views

1 answer

sql - HQL: Is it possible to perform an INNER JOIN on a subquery?

The diagram above is a simplified version of the database structure that I use to log item locations through time. ... in this case? Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags