Recent questions tagged sql

0 votes

313 views

1 answer

sql - Group by two columns and display grand total in every row

Below are the list data. Code ItemCount Type Amount ---------------------------------------- B001 1 ... 00 B001 5 Apple 50.00 B114 2 Apple 40.50 See Question&Answers more detail:os...

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

0 votes

270 views

1 answer

sql - Check if a time is between two times (time DataType)

I have a table that has a column "Created" as a datetime. I'm trying to query to check if the time ... need to convert my times to datetimes? See Question&Answers more detail:os...

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

0 votes

489 views

1 answer

sql server - RAND not different for every row in T-SQL UPDATE

I have the follow T-SQL to update a table with test data: UPDATE SomeTable SET Created = GETDATE ( ) - CAST ... be random every row it updates? See Question&Answers more detail:os...

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

0 votes

558 views

1 answer

sql server - SQL Unpivot multiple columns Data

I am using SQL server 2008 and I am trying to unpivot the data. Here is the SQL code that I am using, CREATE ... to 9. How can I achieve this? See Question&Answers more detail:os...

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

0 votes

649 views

1 answer

sql - "ORA-01438: value larger than specified precision allowed for this column" when inserting 3

I'm running into that error when trying to insert any number except 0 into a field with format NUMBER (2,2) ... decimal numbers. Any idea why? See Question&Answers more detail:os...

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

0 votes

277 views

1 answer

sql - Any reason for GROUP BY clause without aggregation function?

I'm (thoroughly) learning SQL at the moment and came across the GROUP BYclause. GROUP BY aggregates or groups the ... I suspect it is slower. See Question&Answers more detail:os...

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

0 votes

271 views

1 answer

sql - Select values that begin with a number

I have a table with a column containing data that begin with numbers too, on MySQL How can I select the rows that begin only with a number? See Question&Answers more detail:os...

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

0 votes

275 views

1 answer

sql - If I stop a long running query, does it rollback?

A query that is used to loop through 17 millions records to remove duplicates has been running now for about ... WHERE @LoopVar < RecordID) END See Question&Answers more detail:os...

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

0 votes

327 views

1 answer

sql - What does varchar(-1) mean?

What is the meaning of varchar(-1) in SQL Server 2008? Is it an alternative for varchar(max)? See Question&Answers more detail:os...

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

0 votes

485 views

1 answer

sql - SSIS Connection not found in package

I'm kind of new to SSIS programming, and I'm having some problems deploying an SSIS package. This package ... execution failed. The step failed. See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql - Select "where clause" evaluation order

In Sql Server 2005 when I have multiple parameters do I have the guarantee that the evaluation order will always be ... not needed in my case. See Question&Answers more detail:os...

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

0 votes

278 views

1 answer

sql - Addition with NULL values

In a stored procedure (Oracle in my case), I want to add some values to an existing record. Problem is that ... same logic as the above code)? See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql server - How do I use T-SQL Group By

I know I need to have (although I don't know why) a GROUP BY clause on the end of a SQL query ... , and what are the performance ramifications? See Question&Answers more detail:os...

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

0 votes

395 views

1 answer

sql - Stored Procedure parameter default value - is this a constant or a variable

Here is my code: USE [xxx] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[ ... ve just spotted this SO POST See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql mode - MySQL: Setting sql_mode permanently

Via the MySQL command line client, I am trying to set the global mysql_mode: SET GLOBAL sql_mode = TRADITIONAL; ... WAMP package. Thank you. See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

sql server - INNER JOIN with Table-Valued Function not working

I have a table valued function that returns a table. When I try to JOIN the table-valued function with ... Any suggesting why this happens? See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - Possible to do a delete with a HAVING clause?

I want to do something like below: DELETE UserPredictions GROUP BY UserId HAVING COUNT(*) < 500 But I'm getting a ... do a delete with a join? See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql - Only show hours in MYSQL DATEDIFF

I've been busy with this for hours, but I cant get it to work. SQL SELECT DATEDIFF(end_time, start_time) as ` ... I get the 25 hours as output? See Question&Answers more detail:os...

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

0 votes

254 views

1 answer

sql server - Why does Mercurial think my SQL files are binary?

I just scripted out my SQL Server stored procs, table definitions, etc using SQL Server Management Studio, and tried ... that might work, too. See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

sql - Querying more than 65536 rows error in Excel 2013

I am trying to query a spreadsheet using VBA and am running up against a seeming hard limit of 65536 rows ( ... no problem when using MSQuery. See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

sql - How to create BIRT report based on multiple data sets

I need help in creating a BIRT report; the situation is that I have multiple queries but the report all ... ? Million thanks in advance, See Question&Answers more detail:os...

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

0 votes

248 views

1 answer

sql - How to get a value from previous result row of a SELECT statement?

If we have a table called FollowUp and has rows [ ID(int) , Value(Money) ] and we have some rows in it ... best solution for such a problem ? See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - Query combinations with nested array of records in JSON datatype

I'm working on a Rails application that utilizes the Postgres JSON data type. I have a JSON column called data ... to what was described above. See Question&Answers more detail:os...

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

0 votes

625 views

1 answer

sql - Teradata equivalent for lead and lag function of oracle

I have been working ot see the equivalent function for Oracle lead and lag function. The oracle lead would look ... b) LAG_DATE Any better idea See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql server - Count number of NULL values in each column in SQL

I am trying to write a script that will show the number of non-null values in each column as well as ... for each column without listing them? See Question&Answers more detail:os...

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

0 votes

674 views

1 answer

sql - Search by many optional parameters in spring data jpa repository

So I have tables comment and author. I want to build complex search bar with many optional parameters. I want ... best practices in such cases? See Question&Answers more detail:os...

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

0 votes

259 views

1 answer

sql - How to transform rows to columns

I have a simple problem when querying the SQL Server 2005 database. I have tables called Customer and Products (1 ... anybody help me? Thanks! See Question&Answers more detail:os...

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

0 votes

427 views

1 answer

sql - Cumulative sum in Spark

I want to do cumulative sum in Spark. Here is the register table (input): +---------------+------ ... sum of a column on a spark cluster? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags