Recent questions tagged SQL

0 votes

577 views

1 answer

sql - How to create an Index in Amazon Redshift

I'm trying to create indexes in Amazon Redshift but I received an error create index on session_log(UserId); UserId is an integer field. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - No unique or exclusion constraint matching the ON CONFLICT

I'm getting the following error when doing the following type of insert: Query: INSERT INTO accounts (type, ... query is exactly the same. See Question&Answers more detail:os...

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

0 votes

536 views

1 answer

sql - How to convert PostgreSQL 9.4's jsonb type to float

I'm trying the following query: SELECT (json_data->'position'->'lat') + 1.0 AS lat FROM updates LIMIT 5 ... or return NULLs for the uncastable)? See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

sql server - FIFO Implementation in Inventory using SQL

This is basically an inventory project which tracks the "Stock In" and "Stock Out" of items through Purchase and ... other way of doing so? See Question&Answers more detail:os...

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

0 votes

671 views

1 answer

sql - Select * from table1 that does not exist in table2 with conditional

I have 2 tables. One is a table with things that can be learned. There is a JID that desribes each kind ... one being NULL, one being correct. See Question&Answers more detail:os...

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

0 votes

354 views

1 answer

sql - MySql How to set a local variable in an update statement (Syntax?)

How can I set a variable while doing an Update statement? I can't seem to figure out the syntax. So I ... = @tempVariable, @tempVariable := 100; See Question&Answers more detail:os...

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

0 votes

304 views

1 answer

sql - Copy data between two server instances

I want something like : insert into server2.database1.table1 select * from server1.database1.table1 both tables ... two server instances? See Question&Answers more detail:os...

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

0 votes

468 views

1 answer

sql server - Do Stored Procedures really boost performance in MS SQL / .NET?

Jeff Atwood wrote about this here, and while I understand the theoretical performance boost a stored procedure ... be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

445 views

1 answer

sql server - How to return second newest record in SQL?

If this: SELECT * FROM Table WHERE Date=( SELECT MAX(Date) FROM Table ) returns newest record from the table, how to get second newest record? See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql server - SQL - Best practice for a Friendship table

Before you show me duplicates, please note that I've searched through the site an have found some examples but not ... so, can you explain why? See Question&Answers more detail:os...

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

0 votes

377 views

1 answer

sql - How to get column attributes query from table name using PostgreSQL?

I have a project and I need a query to get all attributes of the columns (Column Name, Position, Data Type, Not ... ' But, I need the Comments! See Question&Answers more detail:os...

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

0 votes

534 views

1 answer

sql - Keep only N last records in SQLite database, sorted by date

I have an SQLite database that I need to do the following: Keep only last N records, sorted by date. How do you do that? See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

sql server - I want my database (SQL) to notify or push updates to client application

I was developing this application on VB.net 2010 and SQL 2008. I wanted the clients to be notified for ... available). Thanks in advance! See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql server - Elegant way to delete rows which are not referenced by other table

I have two tables (Tasks and Timeentries), which are connected by a foreign key (TimeEntries.TaskID references ... errors. Please help! See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

sql - How do I get the primary key(s) of a table from Postgres via plpgsql?

Given a table name, how do I extract a list of primary key columns and their datatypes from a plpgsql function? See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

sql - ADD time 23:59:59.999 to end date for between

I have been having an issue with using the following: Column_Name BETWEEN @StartDate AND @EndDate. This is because the ... + 23:59:59.999? See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

sql - What is the difference between rowsBetween and rangeBetween?

From the PySpark docs rangeBetween: rangeBetween(start, end) Defines the frame boundaries, from start (inclusive) to end ... row", for example? See Question&Answers more detail:os...

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

0 votes

420 views

1 answer

sql server - How to convert a datetime to string in T-SQL

I'm surprised not to be able to find this question here already. I have a date time var and I want to convert ... date part and the time part.) See Question&Answers more detail:os...

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

0 votes

483 views

1 answer

sql - Modify table: How to change 'Allow Nulls' attribute from not null to allow null

How to change one attribute in a table using T-SQL to allow nulls (not null --> null)? Alter table maybe? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql - How to change a PG column to NULLABLE TRUE?

How can I accomplish this using Postgres? I've tried the code below but it doesn't work: ALTER TABLE mytable ALTER COLUMN mycolumn BIGINT NULL; See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql - Altering a column to be nullable

I want to alter a table column to be nullable. I have used: ALTER TABLE Merchant_Pending_Functions Modify ... is the correct syntax? See Question&Answers more detail:os...

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

0 votes

462 views

1 answer

sql - Concat the second column value if the first column value is same

I have a query like below and listed output of it: SELECT DISTINCT TRACKING_NUM,TITLE_OF_DOC_SEC FROM some_table ... Section can anyone help? See Question&Answers more detail:os...

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

0 votes

372 views

1 answer

sql server - Getting remote database data into local database in android

We want to get the remote database data into local database first and then we want to access the local ... remote database is MSSQL Server. See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

sql - How do I create a dates table in Redshift?

tl;dr: I want to generate a dates table in Redshift in order to make a report easier to generate. Preferable ... in the same command in Redshift See Question&Answers more detail:os...

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

0 votes

763 views

1 answer

sql - PostgreSql : Json Array to Rows using Lateral Join

I have two following JSON Array in details field of my table and need to evaluate the query as I ... lateral join and json_array_elements_text. See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql - Using Max() function to select group values

I've got a table like this: SKU ITEM VALUE 1503796 1851920 0,9770637 1503796 1636691 0,9747891 1503796 1503781 ... value. How to rewrite query? See Question&Answers more detail:os...

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

0 votes

312 views

1 answer

sql - How keep data don't sort?

I have a Table A: Col1 Col2 12 a 12 c 12 b If i code : Select * from A; Result is: Col1 Col2 12 a 12 b ... 12 c 12 b How get data don't sort? See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - syntax error with update query when join with some table

Here is an API generated query - Not sure what is wrong. UPDATE T123 SET COL1 = 1, VER1 = VER1 + 1 INNER ... as I am getting from some API. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags