Recent questions tagged SQL

0 votes

468 views

1 answer

sql - How to query nested arrays in a postgres json column?

I have some json similar to the json below stored in a postgres json column. I'm trying query it to ... of the addresses of every school? See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql - How do you keep the order using SELECT WHERE IN()?

Is there a way to keep the order when using SELECT WHERE IN()? For example, using the following query: SELECT id ... to order it after in code? See Question&Answers more detail:os...

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

0 votes

344 views

1 answer

sql - How can I further optimize a derived table query which performs better than the JOINed equivalent?

UPDATE: I found a solution. See my Answer below. My Question How can I optimize this query to minimize my ... Thank you so much for reading! See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - one-to-many query selecting all parents and single top child for each parent

There are two SQL tables: Parents: +--+---------+ |id| text | +--+---------+ | 1| Blah | | ... custom ordering). I am totally out of ideas... See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql - move data from one table to another, postgresql edition

I'd like to move some data from one table to another (with a possibly different schema). Straightforward solution ... ? Are there other options? See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - Avg of a Sum in one query

I would like to know if I can get the average of a sum in one single SQL SERVER request, Have tried to do ... FROM TABLE t GROUP BY t.client See Question&Answers more detail:os...

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

0 votes

405 views

1 answer

sql - Selecting entries by date - >= NOW(), MySQL

I have a Calendar of Events table and I would like to select events with dates equal to or greater than today. ... or in the future? Thank you See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql - Maintaining Referential Integrity - Good or Bad?

We are planning on introducing simple Audit Trail in our database using triggers and separate history table for each ... do use hard deletes See Question&Answers more detail:os...

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

0 votes

528 views

1 answer

sql - Convert integer to text in SQLite's SELECT query?

I would like to create a SELECT query that would return numbers from column in integer format as a text format - can I do it in SQLite? See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - Alter data type of a column to serial

In pgsql, is there a way to have a table of several values, and choose one of them (say, other_id), find ... exist Thanks much for any insight! See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql - "ORDER BY ... USING" clause in PostgreSQL

The ORDER BY clause is decribed in the PostgreSQLdocumentation as: ORDER BY expression [ ASC | DESC | USING ... order of the resultset? See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql server - Quickest way to fill SQL Table with Dummy Data

What is the quickest way to fill a SQL table with dummy data? I have a wide table with about 40 fields of ... using SQL Server 2008. Thank you! See Question&Answers more detail:os...

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

0 votes

366 views

1 answer

sql - Using window functions in an update statement

I have a large PostgreSQL table which I access through Django. Because Django's ORM does not support window functions ... which I need. Thanks. See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql server - Unique index or unique key?

What is the diffrence between a unique index and a unique key? See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql - Determine a table's primary key using TSQL

I'd like to determine the primary key of a table using TSQL (stored procedure or system table is fine). Is there ... SQL Server (2005 or 2008)? 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 format bigint field into a date in Postgresql?

I have a table with a field of type bigint. This field store a timestamp. I want to date format the ... multiple decimal points état SQL :42601 See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql server - Select All as default value for Multivalue parameter

I'm building a report in Visual Studio 2008 with a lot of multivalue parameters and it's working great, but I ... I want to run the report? See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

sql - CROSS APPLY vs OUTER APPLY speed difference

I was using CROSS APPLY to join Users and GeoPhone tables and everything worked fast but now I have Users with ... free to comment this out. See Question&Answers more detail:os...

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

0 votes

631 views

1 answer

sql server - How to fix the embedded text qualifier issue while exporting data to CSV flat file?

###RFC 4180: RFC 4180 defines Common Format and MIME Type for Comma-Separated Values (CSV) Files. One of the ... does not conform to RFC 4180 See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - How do I find records that are not joined?

I have two tables that are joined together. A has many B Normally you would do: select * from a,b where b. ... that does not have anything in b? See Question&Answers more detail:os...

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

0 votes

412 views

1 answer

sql - Fast Relational method of storing tree data (for instance threaded comments on articles)

I have a cms which stores comments against articles. These comments can be both threaded and non threaded. ... lightening fast comment pages. See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - PostgreSQL check constraint for foreign key condition

I have a table of users eg: create table "user" ( id serial primary key, name text not null, superuser ... ? Or is there another solution? See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql - Most Executed Stored Procedure?

We created so many inefficient stored procedure in our application, we always postpone to make it more efficient ... is the most executed? See Question&Answers more detail:os...

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

0 votes

738 views

1 answer

sql - Disable secure priv for data loading on MySQL

I'm running MySQL 5.7 on a Windows 10 machine. I've read through all the SO threads on this topic and ... help would be welcome, thank you. See Question&Answers more detail:os...

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

0 votes

386 views

1 answer

sql - Insert multiple rows into single column

I'm new to SQL, (using SQL 2008 R2) and I am having trouble inserting multiple rows into a single column. I ... . What am I doing wrong? Thanks See Question&Answers more detail:os...

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

0 votes

444 views

1 answer

sql - Select multiple rows with the same value(s)

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

0 votes

431 views

1 answer

sql server - Skip-over/ignore duplicate rows on insert

I have the following tables: DataValue DateStamp ItemId Value ---------- ------ ----- 2012-05-22 1 ... the duplicates as it tries to insert? See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - Delete data from all tables in MYSQL

I have 100 tables, 40,000 rows in each table. I want to go into MySQL and delete all rows from all tables ... to keep the database and tables. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags