Recent questions tagged SQL

0 votes

263 views

1 answer

sql - Cross Join without duplicate combinations

I know this question is very similar to this one: Symmetric cross join and this one too: combinations (not permutations) ... equal to (b,a) ? See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql - Does the JDBC spec prevent '?' from being used as an operator (outside of quotes)?

From Sam Macbeth's question: Is there anything in the JDBC spec which allows a ? to be escaped and be ... an operator still be JDBC-compliant? See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql - How to anticipate and escape single quote ' in oracle

Suppose I have a column value as aaa'gh it will throw error in oracle saying sql command not properly ended. ... how can I escape them safely. See Question&Answers more detail:os...

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

0 votes

257 views

1 answer

sql - Update a table with join?

I am trying to update table A with data from table B. I thought I can do something like this update A set ... Invalid token can anyone help me? See Question&Answers more detail:os...

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

0 votes

190 views

1 answer

sql server 2005 - subquery or leftjoin with group by which one is faster?

i have to show running total with the total column in my application ... so i have used the following queries for ... =t1.ind) from @tmp as t1 See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql - Calculating a Moving Average MySQL?

Good Day, I am using the following code to calculate the 9 Day Moving average. SELECT SUM(close) FROM tbl WHERE ... or is there a better way? See Question&Answers more detail:os...

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

0 votes

459 views

1 answer

sql server - Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29

I didn't know where to write something about this and decided to do it here. After loooong time debugging my ... ? :p Best regards, Rui See Question&Answers more detail:os...

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

0 votes

336 views

1 answer

sql server - Does the order of columns in a WHERE clause matter?

Does the order of the columns in a WHERE clause effect performance? e.g. Say I put a column that has a ... for uniqueness first or visa versa? See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - How do I lag columns in MySQL?

Consider the following table: SELECT id, value FROM table ORDER BY id ASC; +-----+---------+ | id | value | + ... .id = t2.id - 2 will not work. See Question&Answers more detail:os...

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

0 votes

189 views

1 answer

sql - Casting NULL type when updating multiple rows

I have a problem when I try to update many rows at the same time. Here is the table and query I use (simplified ... y), pkid:gettype(foo.pkid))? See Question&Answers more detail:os...

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

0 votes

553 views

1 answer

sql - Alternative to using LIMIT keyword in a SubQuery in MYSQL

I have a table TEST with the following columns : code_ver (VARCHAR) suite (VARCHAR) date (DATE) Now I want ... me an alternative to this query? See Question&Answers more detail:os...

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

0 votes

237 views

1 answer

sql - How do I use properly CASE..WHEN in MySQL

Here is a demo query, notice it is very simple, Fetches only where base_price is 0, And still, it chooses the condition 3: ... 3 0 3 0 3 0 3 0 See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - Delete parent if it's not referenced by any other child

I have an example situation: parent table has a column named id, referenced in child table as a foreign key. ... referenced by any other child? See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

sql - PostgreSQL equivalent for TOP n WITH TIES: LIMIT "with ties"?

I'm looking for something similar this in SQL Server: SELECT TOP n WITH TIES FROM tablename I know about LIMIT ... since it ties the other one. See Question&Answers more detail:os...

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

0 votes

317 views

1 answer

sql - Does Oracle use short-circuit evaluation?

I have an Oracle query that is structured as followed: SELECT * FROM table WHERE X='true' OR Y IN (complicated ... Y IN (SELECT id FROM subQ) See Question&Answers more detail:os...

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

0 votes

272 views

1 answer

sql server - How to get the numeric part from a string using T-SQL?

I have the following string. Input -------------- 2030031469-NAI To get the numeric part, I am using ... easy/elegant way of doing the same? See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql server 2008 r2 - Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)

I'm encountering some major performance problems with simple SQL queries generated by the Entity Framework (4.2) ... DBCC TRACEON(4136,-1) See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql - MySQL equivalent of DECODE function in Oracle

I am trying to find an equivalent of DECODE function in MySQL. It works like this: Select Name, DECODE( ... of performance and other reasons. See Question&Answers more detail:os...

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

0 votes

252 views

1 answer

sql server - determining the character set of a table / database?

What T-SQL command can be run to find character set of a table or database in SQL Server? edit: Server version: ... - 10.50.1600.1 (X64) See Question&Answers more detail:os...

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

0 votes

214 views

1 answer

sql - PostgreSQL where all in array

What is the easiest and fastest way to achieve a clause where all elements in an array must be matched - not only ... if querying for (1,2) See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql - MySQL #1093 - You can't specify target table 'giveaways' for update in FROM clause

I tried: UPDATE giveaways SET winner = '1' WHERE ID = (SELECT MAX(ID) FROM giveaways) But it gives: #1093 - ... . How can I get it to work? See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql server - error when inserting into table having instead of trigger from entity data framework

I'm using entity framework 4 , on inserting a new record using entity framework in a table that have instead ... to get around this exception? See Question&Answers more detail:os...

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

0 votes

244 views

1 answer

sql - HAVING without GROUP BY

Is the following possible according to standard(!) SQL? What minimal changes should be neccessary in order to be ... MySQL, it perfectly works. See Question&Answers more detail:os...

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

0 votes

336 views

1 answer

sql - Why is a UDF so much slower than a subquery?

I have a case where I need to translate (lookup) several values from the same table. The first way ... issue to readability and maintainability. See Question&Answers more detail:os...

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

0 votes

267 views

1 answer

sql - "You tried to execute a query that does not include the specified aggregate function"

SELECT SUM(orders.quantity) AS num, fName, surname FROM author INNER JOIN book ON author.aID = book.authorID; I ... function. What do I do? See Question&Answers more detail:os...

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

0 votes

225 views

1 answer

sql server - How to query values from xml nodes?

i have a table that contains an XML column: CREATE TABLE Batches( BatchID int, RawXml xml ) The xml contains ... closer to solving the problem. See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql server - How to update primary key

Here is my problem - I have 2 tables: WORKER, with columns |ID|OTHER_STAF| , where ID is primary key FIRM, ... of specific value of ID in FIRM. See Question&Answers more detail:os...

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

0 votes

547 views

1 answer

sql - Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I am trying to deploy my website on windows server 2003. Am i missing something or what is wrong ... in C:DevCodeAPIDataSessionManager.cs:27 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags