Recent questions tagged SQL

0 votes

337 views

1 answer

How could I perform a simple range query in SQLite efficiently? Say, I have data that saves a person ... make the searching more efficient? See Question&Answers more detail:os...

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

0 votes

274 views

1 answer

sql - Identifying transitive dependencies

I am working with a table that has a composite primary key composed of two attributes (with a total of 10) ... student may have only one major. See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

sql - #1452 - Cannot add or update a child row: a foreign key constraint fails

When I wan't to connect two tables with eachother then I get the message : #1452 - Cannot add or ... Primary Unique Index Spatial Fulltext See Question&Answers more detail:os...

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

0 votes

564 views

1 answer

sql - Select * from table OR select id,field1, field2, field3 from table - best practice?

Could someone chime in as to whats a better practice? for select queries should I return all or the IDs that I ... SQL Server 2008, VS2008 (VB) See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql - Oracle: multiple table updates => ORA-01779: cannot modify a column which maps to a non key-preserved table

I've made a Join between tables. I simply want to take the values from some data and put into the ... aggiornare (estratto nella prima query) See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql - Conditions in LEFT JOIN (OUTER JOIN) vs INNER JOIN

SELECT A.COL1, B.COL1,C.COL1 FROM TABLEA A LEFT JOIN TABLEB B ON A.COL1 = B.COL1 LEFT JOIN TABLEC C ON ... C ON mean? Why are those necessary? See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

sql - Oracle, split a time duration row by one hour period

I'm working on oracle db and I'm not quite good at Oracle. I'm trying to split a row by one hour ... help will be great. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - Get envelope.i.e overlapping time spans

I have a table with online sessions like this (empty rows are just for better visibility): ip_address | ... Analytic Function would be great. See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql - Transpose select results with Oracle

my question is, with some background: I have to generate some sql queries based on the table metadata (column ... SQL? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

334 views

1 answer

sql - Grant access to just one schema in postgreSQL

I have a user just_one_schema_user. In my database I have two schemas: public and sample How can I make ... public and see their structures. See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql - parameterized query in ms access 2003 using vba

Ok. I want to use parameterized queries to avoid dealing with embedded double or single quotes (" or ') in my ... joins). Thanks for any advice See Question&Answers more detail:os...

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

0 votes

886 views

1 answer

sql - Is there a script to bypass 50000 characters for in-cell formula?

I have this (insanely) long formula I need to run in Google Sheets, and I came across the limit error: ... even 500000 limits for total cells See Question&Answers more detail:os...

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

0 votes

316 views

1 answer

sql - Summarize the list into a comma-separated string

This is the current result that can be changed from day to day (int) (nvarchar) Number Grade -------------- 1 a 1 c 2 ... a, c 2 a, b, c 3 b, a See Question&Answers more detail:os...

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

0 votes

350 views

1 answer

sql server - loss of scale when performing calculation

I'm performing a calculation and I don't get the answer I expect. I lose some scale doing the calculation. ... 269.33213191 (correct to 8dp)? See Question&Answers more detail:os...

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

0 votes

378 views

1 answer

sql server - Problem with creating .MDF file from Visual Studio 2010

I am trying to create a small wpf application by using mdf. The problem is that when I am trying to add ... installed. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql server - Set based plan runs slower than scalar valued function with many conditions

This question is a bit more of a hypothetical than an actual code problem. But I have provided a dumbed ... I missing something obvious here? See Question&Answers more detail:os...

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

0 votes

314 views

1 answer

sql - How can I select only the first distinct match from a field in MySQL?

How can I only return the first distinct match of a field in MySQL? My Table: name hash --------- ... distinct matches, like Andrew or Anthony). See Question&Answers more detail:os...

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

0 votes

275 views

1 answer

sql - Simple update statement so that all rows are assigned a different value

I'm trying to set a column in one table to a random foreign key for testing purposes. I attempted using the ... more concise way of doing it. See Question&Answers more detail:os...

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

0 votes

460 views

1 answer

sql - Update values in struct arrays in BigQuery

I am looking for an easy way to update values inside array of structs using SQL. Let's say we have a table: ... all dragon names to a cat. See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql - Continuing Inserts in Oracle when exception is raised

I'm working on migration of data from a legacy system into our new app(running on Oracle Database, ... , the procedure terminates execution. See Question&Answers more detail:os...

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

0 votes

336 views

1 answer

sql - Recursive query in Oracle

I am kind of new to the more advanced topics of PLSQL, so hopefully someone can help me out. The problem: ... am having trouble figuring it out. See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - MySQL IN with LIKE

How would I use a IN table with like? So that I could use % in them? By in I mean: SELECT fields FROM ... "Operand should contain 1 column(s)" See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql server - Dynamic Translate to avoid C# syntax errors

Consider the following database table (SQL Server 2005). I'd like to use this in EF (v6, .net 4 ... load data without using Translate? See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql server - PHP on IIS7 with (PDO) MS-SQL support

I'm running an IIS 7 windows server and a relevant part of my phpinfo's configure command currently reports this ... that a command line thing? See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - mysql delete,autoincrement

I have a table in MySQL using InnoDB and a column is there with the name "id". So my problem is that ... insert after deleting the last column. See Question&Answers more detail:os...

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

0 votes

5.8k views

1 answer

sql - ORA-00904 "Invalid identifier” for an identifier in a group by clause

with compiere database i am trying ro show between two dates. column: designation qty sale (depot) client sales qty- ... la ligne 75, colonne 3 See Question&Answers more detail:os...

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

0 votes

285 views

1 answer

sql - Find out which schema based on table values

My database is separated into schemas based on clients (i.e.: each client has their own schema, with same data ... them, one at a time? See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql server - TSQL Round up decimal number

I have this number 0.581183781439, I need to round the number 0.582 I was trying with SELECT ROUND (0. ... it useful ROUND function for this? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags