Recent questions tagged SQL

0 votes

469 views

1 answer

sql - A constraint that only allows one of two tables to reference a base table

I have 3 tables. A base table, call it Table A, and two tables that reference Table A, Call them Table X ... have one. Is this possible? Thanks, See Question&Answers more detail:os...

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

0 votes

421 views

1 answer

sql - How to return only work time from reservations in PostgreSql?

Select from great answer in How to find first free time in reservations table in PostgreSql create table reservation ( ... 00" how to fix ? See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql - How to use array_agg() for varchar[]

I have a column in our database called min_crew that has varying character arrays such as '{CA, FO, FA}'. I have a ... and seids = '{623, 625}'. See Question&Answers more detail:os...

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

0 votes

690 views

1 answer

sql - Vector (array) addition in Postgres

I have a column with numeric[] values which all have the same size. I'd like to take their element-wise average. By ... 3, 3}'::numeric[]) ; See Question&Answers more detail:os...

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

0 votes

728 views

1 answer

sql - how to concatenate strings?

I'm on Oracle 10g and have the following table structure: id, paragraph I want to group by id and concatenate the ... id how do I solve this? See Question&Answers more detail:os...

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

0 votes

572 views

1 answer

sql - Group records by time

I have a table containing a datetime column and some misc other columns. The datetime column represents an event ... would not be a problem) See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

sql - Is it possible to concatenate column values into a string using CTE?

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

0 votes

573 views

1 answer

sql server 2008 - Merge adjacent rows in SQL?

I'm doing some reporting based on the blocks of time employees work. In some cases, the data contains two ... but that is not required. See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

sql - MSSQL: Update statement avoiding the CHECK constraint

Working in MS2000, I have a table called JobOwners that maps Jobs (JPSID) to the Employees that own them ... appreciated. Thank you, Ben See Question&Answers more detail:os...

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

0 votes

523 views

1 answer

sql server - SQL: Select Top 3 Records + Sum of Quantity

I would like to display the top 3 records from the existing Orders table. In order to accomplish this, I need to ... Quantity 1 170 2 70 4 50 See Question&Answers more detail:os...

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

0 votes

798 views

1 answer

sql - Deduplicate rows in a BigQuery partition

I have a table with many duplicated rows - but I only want to deduplicate rows one partition at a time. ... FROM UNNEST(GENERATE_ARRAY(1, 100)) See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

sql - Database: Pipelined Functions

I am new to the concept of Pipeline Functions. I have some questions regarding From Database point of view: ... Pipeline Function ? Thanks. See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

sql - Crystal Reports Need to Group by Derived Date Range

Long time listner, first time caller. I'm using Crystal Reports 2010. I have daily trade information that I need ... with Crystal. Any ideas?? See Question&Answers more detail:os...

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

0 votes

664 views

1 answer

sql like - What does (backslash) mean in an SQL query?

I have the following query SELECT txt1 FROM T1 WHERE txt1 LIKE '_a\%' will that result in answers that have ... normally inside an SQL query?? See Question&Answers more detail:os...

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

0 votes

605 views

1 answer

sql server - "Must declare the variable @myvariable" error with ADO parameterized query

i am trying to use parameterized queries with ADO. Executing the Command object throws the error: Must declare the ... What am i doing wrong? See Question&Answers more detail:os...

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

0 votes

465 views

1 answer

sql server - How to convert row values to columns with dynamic columns count?

I have the following data: DECLARE @DataSource TABLE ( [ColumnA] INT ,[ColumnB] INT ,[ColumnC] INT ) ... , suggestions) will be appreciated. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

sql server - PHP, ORM, MSSQL and Unicode, is it possible to make these work together?

If you are saving unicode data to MSSQL you need to save into a column type nvarchar (et. al) and you must ... with Unicode/UTF-8 and mssql. See Question&Answers more detail:os...

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

0 votes

543 views

1 answer

sql - AUTONOMOUS_TRANSACTION

I was thinking of using AUTONOMOUS_TRANSACTION Pragma for some logging in a batch process. Does anyone have any ... cons would be appreciated. See Question&Answers more detail:os...

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

0 votes

983 views

1 answer

sql - MySQL LOAD DATA Error (Errcode: 2 - "No such file or directory")

I am trying to load data into a table of my MySQL database, and getting this error. LOAD DATA LOCAL INFILE ' ... than an absolute path) here? See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

sql - MySQL retrieve latest record for Group

I have a social networking site and am struggling with a query. I have a posts table that holds all of the ... the newest comment for each post? See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql - How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am ... with this issue. Thanks In advance See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

sql server - PIVOT on Common Table Expression

I have a CTE as follows WITH details AS ( SELECT FldId ,Rev ,Words ,row_number() OVER ( PARTITION BY ... Requirements here Pls. suggest. Thanks See Question&Answers more detail:os...

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

0 votes

608 views

1 answer

sql - Many-to-many relations in RDBMS databases

What is the best way of handling many-to-many relations in a RDBMS database like mySQL? Have tried using ... support many-to-many relationships? See Question&Answers more detail:os...

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

0 votes

508 views

1 answer

sql - select every other row in MySQL without depending on any ID?

Considering following table that doesn't have any primary key, can I select every other row? col1 col2 2 a 1 b 3 ... : 1, 12 is that possible? See Question&Answers more detail:os...

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

0 votes

585 views

1 answer

sql - why "extra characters after command" error shown for the sed command line shown?

I have given the command line as shown below, command: sed '/dump 0 $2 $3 $4 $5/dump 1 $2 $3 $4 $5/g' ... #1, char 32: unknown option to `s' See Question&Answers more detail:os...

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

0 votes

529 views

1 answer

sql - MS Access Create Table with Autoincrement and default date

I try to create MS Access Table with autoincrement ID and Default Date field, but next query always says "Syntax ... to fix that query. Thanks! See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

sql - How to create a Postgres table with unique combined primary key?

I have two tables named players & matches in a Postgres DB as follows: CREATE TABLE players ( name text ... matches between the same players. See Question&Answers more detail:os...

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

0 votes

590 views

1 answer

sql server - How to Parse a comma delimited string of numbers into a temporary orderId table?

I have a bunch of orderIds '1, 18, 1000, 77 ...' that I'm retreiving from a nvarchar(8000). I am ... able to do this: select orderid from #temp See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags