Recent questions tagged SQL

0 votes

716 views

1 answer

sql - BigQuery - Joining on multiple conditions using subqueries and OR statements

Is there anyway to join two tables on multiple potential conditions? I'm currently migrating some code from Postgres ... of doing the above? See Question&Answers more detail:os...

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

0 votes

313 views

1 answer

sql - MySQL - Cannot Create View with SET variable inside

I am trying to create a view with SET @rank = 0; inside but it's giving me errors. Been trying different things but it ... ', ei.SM, ' at line 2 See Question&Answers more detail:os...

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

0 votes

307 views

1 answer

sql server - How to Change All Sql Columns of One DataType into Another

I have a database (Sql Server 2005) where there are dozens of tables, each of which has a number of columns ( ... the db, whichever is easier). See Question&Answers more detail:os...

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

0 votes

688 views

1 answer

sql - DB2 Using LIMIT and OFFSET

I am developing a Java Web service allow paging when fetching big data set from a DB2 Database on ... DB2_COMPATIBILITY_VECTOR variable to MYS? See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql server - RESEED identity columns on the database

Can I use the DBCC CHECKIDENT(<table_name>, RESEED, value) command to reset an identity column current value to ... alternate way of doing this? See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql server - SQL Joins: Future of the SQL ANSI Standard (where vs join)?

We are developing ETL jobs and our consultant has been using "old style" SQL when joining tables select a.attr1, ... inner join" style of joins. See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql - Syntax for input parameters in a MySQL query

We recently switched a database from MSSQL to MySQL and the queries that uses parameters does'nt work anymore. Here ... in advance for the help. See Question&Answers more detail:os...

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

0 votes

411 views

1 answer

sql server - SQL Identity with leading padded zeros

I have marked a column as Identity in my table create table Identitytest( number int identity(1,001) not null, value ... . How can this be done? See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

sql - MYSQL - Concatenate two tables

I have two tables as follows: TABLE A TABLE B StuID | actid FacID | actid 3 12 98 17 5 17 54 21 I ... guess I need a form of concatenation?? See Question&Answers more detail:os...

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

0 votes

351 views

1 answer

sql - Mysql workaround for window functions

I have an event table that has the following fields: event_id event_type event_time Given a duration D and a number ... under 1 million rows.) See Question&Answers more detail:os...

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

0 votes

623 views

1 answer

sql - BigQuery IF field exists THEN

I'm running a query over multiple tables unioned together over a particular time range. In the past, a ... "my_field" FROM <somewhere> See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql - Optimizing my mysql statement! - RAND() TOO SLOW

So I have a table with over 80,000 records, this one is called system. I also have another table called follows ... down a whole bunch. Thanks! See Question&Answers more detail:os...

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

0 votes

682 views

1 answer

sql - LIMIT ignored in query with GROUP_CONCAT

I need to select some rows from second table and concatenate them in comma-separated string. Query works well except ... ORDER BY t1.date desc See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - Alter Column datatype with primary key

I have a ReferenceID varchar(6) column in over 80 different tables. I need to extend this to a varchar(8) ... table we're currently looking at? See Question&Answers more detail:os...

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

0 votes

453 views

1 answer

sql server - Parse a date from unformatted text in SQL

I'm trying to figure out an elegant way to get a date from a text column that has data like this " ... in a single query. Any suggestions? See Question&Answers more detail:os...

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

0 votes

648 views

1 answer

sql server - Passing Table Valued parameter to stored procedure across different databases

I'm using SQL Server 2008. How can I pass Table Valued parameter to a Stored procedure across different Databases, ... for any kind of help. See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

sql - Redshift: Executing a dynamic query from a string

I would like to execute a dynamic SQL query stored in a string field on Amazon Redshift. My background is ... really build dynamic SQL code? See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql - Does deleting row from view delete row from base table - MySQL?

Deleting a row from a view, will it delete the appropriate rows from the base tables that the view was created upon? I am using MySQL. See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql server - order by a parameter

Hi i have a store procedure, where i do a select query. I want order this by an external parameter. I post ... in order by for do that? thanks See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql server - Re-use aliased field in SQL SELECT statement

I'd like to achieve something like this: SELECT (CASE WHEN ...) AS FieldA, FieldA + 20 AS FieldB FROM Tbl ... statement is no good in my case. See Question&Answers more detail:os...

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

0 votes

561 views

1 answer

sql server - SQL - safely downcast BIGINT to INT

I have a CSV I'm importing into our database. One of the "columns" contains data that should be an INT ... int.MaxValue)? EDIT: Corrected typo. See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

sql server - sql varchar(max) vs varchar(fix)

Every time I confused for selecting varchar(max) or varchar(fix) datatype. suppose I have a data column that ... is an effect on performance. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - Why does running this query with EXECUTE IMMEDIATE cause it to fail?

I am writing a PL/SQL procedure that needs to to dynamically generate some queries, one of which involves ... what is causing the problem. See Question&Answers more detail:os...

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

0 votes

324 views

1 answer

sql server - SQL Query for Grouping the results based on sequence

I have a table like this: ID Seq Amt 1 1 500 1 2 500 1 3 500 1 5 500 2 10 600 2 11 600 3 1 700 ... 3 3 3 700 Please help to achieve this result. See Question&Answers more detail:os...

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

0 votes

481 views

1 answer

sql - MySQL select MAX(datetime) not returning max value

Example table: id computer app version build date ---|---------|------|------------|-------| ... go bald by scratching my head because of this. See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql server - Why precision is decreasing when multiply sum to other number

I have encountered with following bug (or feature) in SQL Server. When I use SUM (*column*) where column has ... , 2005 and 2008 SQL Server. See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql - Why doesn't Oracle raise "ORA-00918: column ambiguously defined" for this query?

I've just come across a strange behaviour in Oracle where I would expect ORA-00918 to be raised, but isn't. ... it fixed in an earlier version! See Question&Answers more detail:os...

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

0 votes

744 views

1 answer

sql - CREATE VIEW must be the only statement in the batch

I'm trying to make a view. So far, I have written this: with ExpAndCheapMedicine(MostMoney, MinMoney) as ( select max ... " How can I fix this?! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags