Recent questions tagged SQL

0 votes

996 views

1 answer

sql - How do I select only the latest entry in a table?

I have a 3 table SQLServer Database. Project ProjectID ProjectName Thing ThingID ThingName ProjectThingLink ProjectID ThingID ... of doing this? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Time difference in hours and seconds over a partition window in Teradata (Sessionizing Records)

Given a table like this: cust_id time 123 2015-01-01 12:15:05 123 2015-01-01 12:17:06 123 2015-01- ... tossing a window function into the mix. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - tsql aggregate string for group by

I have two tables: Names(id, name) Addresses(id, name_id, address) I want to write query that return me: name, ... name_id) B ON A.id=B.name_id See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Deleting duplicate records using a temporary table

Take the tsql query below: DECLARE @table TABLE(data VARCHAR(20)) INSERT INTO @table VALUES ('not duplicate row ... query was found here Thanks See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql server - How to generate minute intervals between two dates in T-SQL?

I have a table of startTime and endTimes. I need to generate a table of intervals between those two dates in ... 09:00 in 10 minute increments. See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

sql - Choose AS400 query records directly from Excel

I've been searching the internet for hours trying to figure out if the following is even possible: To ... ideas are greatly appreciated :) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - Inserting and transforming data from SQL table

I have a question which has been bugging me for a couple of days now. I have a table with: Date ID Status_ID ... that they are now grouped by. See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

sql server - How to use GROUP_CONCAT function on MSSQL

How can I use the GROUP_CONCAT function on MSSQL while MySQL is running? current table; QUESTION_ID ANSWER_ID USER 1. ... C thanks in advance.. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql - Calculate difference between start_time and end_time in seconds from unix_time yyyy-MM-dd HH:mm:ss

I'm still learning SQL and I found a couple of solutions on SQL Server or Postgreы, but it doesn't seen to ... 14:01:17 desired output 01:36 See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - ORA-00600 When running ALTER command?

I am running this command on a table : ALTER TABLE testTable ADD column1 NUMBER(1) DEFAULT 0 NOT NULL; And ... number Any thoughts on this? See Question&Answers more detail:os...

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

0 votes

931 views

1 answer

sql - Text values in a pivot table?

I have a table (in MySQL) with 3 columns: Location Category Supplier A Computers Company X A Printers Company Y B ... Excel myself. Any idea's? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - MySQL trigger: Update when reaching a certain datetime

I want to create a MySQL trigger that updates a table everytime one of the datetime rows in a different table ... the counter upped by 1. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

sql - PATINDEX() replacement in MYSQL

i am converting a sql server script where i need to convert PATINDEX() in MYSQL. would you please suggest ... function is similar to PATINDEX() See Question&Answers more detail:os...

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

0 votes

927 views

1 answer

sql - Recursive select?

I have the following table structure: So each forum post has a parent, who also has a parent(except the ... Any help is appreciated. Thanks. See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

sql - Add value to a column each month in Mysql Data Base

is there a way to update automatically the values of a column in a table in Mysql DB with a predifined value ... two years for each employee. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Select Records multiple times from table

I have a SQL statement like this: EDIT : SELECT location as Location FROM Table1 WHERE OnsiteOffshore = 'Offshore' AND ... how to get the same. See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

sql - Cross Join in Entity framework Lambda Expressions

How can I do the following join in EF? Tables have no relation with each other, no foreign keys. Select t1. ... t2 where t1.firstname = t2.name See Question&Answers more detail:os...

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

0 votes

865 views

1 answer

sql - IS NOT NULL test for a record does not return TRUE when variable is set

Using a plpgsql procedure to extract a record if it exists, and then if it does, do something with it. The ... row from a SELECT * INTO? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Is querying on views slower than doing one query?

Will Mssql be even fast when I query on a view opposed to one query? example When I have this ... Invoices.CustomerID where customername="Bart" See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

sql - Good database and structure to store synonyms

If you could choose the database you want and have to store (query and update) word synonyms then what database would ... 't be a problem here). See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Insert into temp values (select.... order by id)

I'm using an Informix (Version 7.32) DB. On one operation I create a temp table with the ID of a regular ... page, then 500 in the next page See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

sql - Oracle AS keyword and subqueries

Just found out that Oracle does not like it when you use the AS keyword to alias a subquery: SELECT * ... above query affect any other RDBMS? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql server - SMO ConnectionContext.StatementTimeout setting is ignored

I am successfully using Powershell with SMO to backup most databases. However, I have several large databases in which I ... 05/06/2010 15:43:23 See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Reverse in Oracle this path z/y/x to x/y/z

How would I do in a SELECT query to reverse this path : z/y/x for x/y/z where / is the delimiter and where ... /v/u ...) reversed_path from ... See Question&Answers more detail:os...

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

0 votes

975 views

1 answer

sql - Using INSERT INTO with 'SELECT' to supply some values but not others (Access 2010)

I have two tables that look like this: ('MASTER_EOD' TABLE) ID SHA1_HEX ROLE -------------------- ... Access is throwing the error that it does. See Question&Answers more detail:os...

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

0 votes

993 views

1 answer

sql - MySQL COUNT() multiple columns

I'm trying to fetch the most popular tags from all videos in my database (ignoring blank tags). I also need the 'flv' for ... ----------------+ See Question&Answers more detail:os...

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

0 votes

925 views

1 answer

sql - Query with many CASE statements - optimization

I have one very dirty query that per sure can be optimized because there are so many CASE statements in it! ... welcome! TnX in advance! Nemanja See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - MySQL: You can't specify target table 'tasks' for update in FROM clause

I have got MySQL error "You can't specify target table 'tasks' for update in FROM clause" running the following ... can I manage this? Thanx! See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags