Recent questions tagged SQL

0 votes

446 views

1 answer

sql - Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine

I have a sqlite (v3) table with this column definition: "timestamp" DATETIME DEFAULT CURRENT_TIMESTAMP The server that ... it from the table? See Question&Answers more detail:os...

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

0 votes

464 views

1 answer

sql - How can a LEFT OUTER JOIN return more records than exist in the left table?

I have a very basic LEFT OUTER JOIN to return all results from the left table and some additional ... simply confuse matters. /Postscript See Question&Answers more detail:os...

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

0 votes

309 views

1 answer

sql - Fastest check if row exists in PostgreSQL

I have a bunch of rows that I need to insert into table, but these inserts are always done in batches. So ... means they all are present there. See Question&Answers more detail:os...

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

0 votes

390 views

1 answer

sql - Disable all table constraints in Oracle

How can I disable all table constrains in Oracle with a single command? This can be either for a single table, a ... tables, or for all tables. See Question&Answers more detail:os...

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

0 votes

519 views

1 answer

sql - MySQL: How to copy rows, but change a few fields?

I have a large number of rows that I would like to copy, but I need to change one field. I can select the ... to 155. How can I accomplish this? See Question&Answers more detail:os...

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

0 votes

295 views

1 answer

sql server - SQL "select where not in subquery" returns no results

Disclaimer: I have figured out the problem (I think), but I wanted to add this issue to Stack Overflow since I ... SQL Server, if it matters.) See Question&Answers more detail:os...

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

0 votes

246 views

1 answer

sql - How to create a multi-tenant database with shared table structures?

Our software currently runs on MySQL. The data of all tenants is stored in the same schema. Since we are using ... -multi (10.000+ tenants). See Question&Answers more detail:os...

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

0 votes

396 views

1 answer

sql - What is the difference between Views and Materialized Views in Oracle?

What is the difference between Views and Materialized Views in Oracle? See Question&Answers more detail:os...

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

0 votes

233 views

1 answer

sql - Best database field type for a URL

I need to store a url in a MySQL table. What's the best practice for defining a field that will hold a URL with an undetermined length? See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql - Postgres error updating column data

Trying to run a update script on a table, but getting an error: ERROR: column "ok" does not exist LINE 2: ... phone="000" WHERE employee_id = 1; See Question&Answers more detail:os...

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

0 votes

256 views

1 answer

sql - Dynamic "string" in R

Simple question, but cannot find the answer. Instead of: Df <- sqlQuery(ch, "SELECT * FROM tblTest WHERE Id=25") ... )) But this is not correct. See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - PIVOT query on Distinct records

I have below table: ------------------------------------------------------ | Id Code ... VALUES (1,'Prashant',73,'Sam','Sam_','Cooking 1') See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - COPY with dynamic file name

I am trying to write a function to load csv data into a table. I want the input argument to be the path to the ... at $1 What's wrong with it? See Question&Answers more detail:os...

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

0 votes

201 views

1 answer

sql - Varchar variable is not working in WHERE clause

Why does this work... DECLARE @MyInt int = 12345; SELECT * FROM MyTable WHERE MyId = @MyInt; --Returns 1 ... SQL Server version is 10.50.1746 See Question&Answers more detail:os...

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

0 votes

228 views

1 answer

sql server - Possible to store value of one select column and use it for the next one?

Is it possible to store or cache values that are part of one select column and then be used for the next ... write the same complex query twice? See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql server - How do I pass value to a stored procedure parameter in OLE DB Source component?

I am working with SSIS 2008. I have a select query name sqlquery1 that returns some rows: aq dr tb This query is ... I need to do this in SSIS? See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql server - Transpose rows and columns with no aggregate

I have the following dataset Account Contact 1 324324324 1 674323234 2 833343432 2 433243443 3 787655455 4 ... unfixed amount of Contacts See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - How to populate calendar table in Oracle?

I want to maintain a calender table in Oracle DB which I want to populate with all the days of the year ... only here (DayName is optional). See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql - Why do NULL values come first when ordering DESC in a PostgreSQL query?

When would you ever want NULLS first when ordering a query descending or ascending? In my opinion, the vast ... have to specify NULLS FIRST. See Question&Answers more detail:os...

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

0 votes

263 views

1 answer

sql - Why can't I use column aliases in the next SELECT expression?

Can I modify the next to use the column aliases avg_time and cnt in an expression ROUND(avg_time * cnt, 2)? ... ORDER BY avg_time DESC LIMIT 10; See Question&Answers more detail:os...

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

0 votes

376 views

1 answer

sql - How to calculate the number of "Tuesdays" between two dates in TSQL?

I'm trying to figure out how to calculate the number of "Tuesdays" between two dates in TSQL? "Tuesday"could be any value. See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

sql server - SQL comma-separated row with Group By clause

I have the following query: SELECT Account, Unit, SUM(state_fee), Code FROM tblMta WHERE MTA.Id = '123' GROUP ... that worked with a group by. See Question&Answers more detail:os...

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

0 votes

297 views

1 answer

sql - A way to extract from a DateTime value data without seconds

I have an sql DateTime (ms sql server) and want to extract the same date without the seconds: e.g. ... error prone (besides performance issues) See Question&Answers more detail:os...

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

0 votes

466 views

1 answer

sql server - MySQL Aggregate Functions without GROUP BY clause

In MySQL, I observed that a statement which uses an AGGREGATE FUNCTION in SELECT list gets executed though there ... MySQL? Thanks in advance!! See Question&Answers more detail:os...

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

0 votes

205 views

1 answer

sql - passing table and column name dynamically using bind variables

Is there a way to pass column and table names dynamically to a query using bind variables? This ... traditional approach of concatenation? See Question&Answers more detail:os...

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

0 votes

210 views

1 answer

sql server - Pivot data in T-SQL

I have a group of people. Lets call them A,B,C. I have a table that shows how much they were paid each ... it is a common problem any ideas? See Question&Answers more detail:os...

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

0 votes

251 views

1 answer

sql - Is there a nesting limit for correlated subqueries in some versions of Oracle?

Here is the code that will help you understand my question: create table con ( content_id number); create ... looping and/or temporary tables? See Question&Answers more detail:os...

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

0 votes

296 views

1 answer

sql - Special Characters in MySQL Table Name

I created a table as follows: CREATE TABLE IF NOT EXISTS 'e!' ( `aa` int(11) unsigned NOT NULL ... have to encode them somehow? Thanks. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags