Recent questions tagged SQL

0 votes

311 views

1 answer

sql - Is MySQL LIMIT applied before or after ORDER BY?

Which one comes first when MySQL processes the query? An example: SELECT pageRegions FROM pageRegions WHERE(pageID=? ... applied after ORDER BY? See Question&Answers more detail:os...

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

0 votes

308 views

1 answer

sql - Update if different/changed

Is it possible to perform an update statement in sql, but only update if the updates are different? for ... this should perform an update. See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql server - How do I execute a stored procedure in a SQL Agent job?

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server ... procedure to execute in SQL Server Job? See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sql - Split string and take last element

I have a table with this values: Articles/Search/ArtMID/2681/ArticleID/2218/Diet.aspx OurStory/MeettheFoodieandtheMD.aspx ... can i do this? See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - Do indexes work with "IN" clause

If I have a query like: Select EmployeeId From Employee Where EmployeeTypeId IN (1,2,3) and I have an index ... SQL server still use that index? See Question&Answers more detail:os...

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

0 votes

496 views

1 answer

sql - What is the best way to escape non-format characters in Oracle's to_char?

I am trying to print a date in a select statement, but I need to add a letter to the output: to_char( ... it with a backslash or something? See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql server - Test Column exists, Add Column, and Update Column

I'm trying to write a SQL Server database update script. I want to test for the existence of a column in a ... but I'm getting nowhere fast. See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

sql - Select columnValue if the column exists otherwise null

I'm wondering if I can select the value of a column if the column exists and just select null otherwise. In ... the columns on your sub query. See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - Referencing outer query's tables in a subquery

Is it possible to reference an outer query in a subquery with MySQL? I know there are some cases where ... that associates table rows correctly. See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

sql - what's the escape sequence for hyphen (-) in PostgreSQL

I'm trying to rename a database to a name with a hyphen (-). ALTER DATABASE one RENAME TO one-two; And psql ... and didn't work as well. Thanks. See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

sql - Is there a way to persist a variable across a go?

Is there a way to persist a variable across a go? Declare @bob as varchar(50); Set @bob = 'SweetDB'; GO ... question for the 'USE @bob' line. See Question&Answers more detail:os...

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

0 votes

549 views

1 answer

sql - MySQL Select rows where timestamp column between now and 10 minutes ago

I have a timestamp column that auto updates on insert/update. I want to get the rows that have been ... ORDER BY stamp_updated DESC LIMIT 1 See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql - Best way to get the next id number without "identity"

I have to insert some records in a table in a legacy database and, since it's used by other ancient ... other guys that contributed! Awesome! See Question&Answers more detail:os...

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

0 votes

418 views

1 answer

sql - mysql query to select everything except

i have two mysql tables. the first is called "chosen" and consists of id, user_id, and widget_id fields. the other ... ) how do i do this? See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - Postgresql recursive self join

My table in postgres looks like below, Table stores a chain sort of relation between IDs and I want to have a ... tail(last in the chain) id. See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

sql server - Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu

I'm trying to get MSSQL working on Ubuntu 12.04 via ODBC, and I've followed these steps to the letter: http:// ... at it, and it didn't work. See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql - Order by day_of_week in MySQL

How can I order the mysql result by varchar column that contains day of week name? Note that MONDAY should goes first, not SUNDAY. See Question&Answers more detail:os...

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

0 votes

368 views

1 answer

sql server - Where to use Outer Apply

MASTER TABLE x------x--------------------x | Id | Name | x------x---------------- ... should I use LEFT JOIN AND where should I use OUTER APPLY See Question&Answers more detail:os...

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

0 votes

268 views

1 answer

sql server - How to search all text fields in a DB for some substring with T-SQL

I have a huge schema, with several hundreds of tables and several thousands of columns. I'd know that a specific IP ... '10.15.13.210' etc. See Question&Answers more detail:os...

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

0 votes

444 views

1 answer

sql - SQLite: Preventing Duplicate Rows

CREATE TABLE Permission ( permissionID INTEGER PRIMARY KEY UNIQUE, user INTEGER location INTEGER ); I don't want to ... can I avoid duplicates? See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

sql - Select multiple (non-aggregate function) columns with GROUP BY

I am trying to select the max value from one column, while grouping by another non-unique id column which has ... should I go about doing this? See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql - Mysql: Swap data for different rows

Suppose a table fruits that looks like this: ------------------------------------------ | ... and things like that. Note: id is unique Thank you See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql - MySQL: How to SUM() a TIMEDIFF() on a group?

So I've got a set of results that looks something like this: SELECT User_ID, StartTime, EndTime, TIMEDIFF( ... the TimeDiffs for each User? See Question&Answers more detail:os...

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

0 votes

312 views

1 answer

sql - What are the pros and cons of using multi column primary keys?

I would like to see an example of: When this is appropriate When this is not appropriate Is there a time ... difference to the above examples? See Question&Answers more detail:os...

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

0 votes

476 views

1 answer

sql - JOIN three tables

I am trying to retrieve two sets of information (the red and blue portions of the diagram in the one query. ... segments. Thanks in advance =] See Question&Answers more detail:os...

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

0 votes

510 views

1 answer

sql server - Using LIKE operator with stored procedure parameters

I have a stored procedure that uses the LIKE operator to search for a truck location among some other parameters ... full name of the location See Question&Answers more detail:os...

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

0 votes

446 views

1 answer

sql server - Printing Table's structure/schema

I have like 20 or so tables in the database RentalEase and I want to print them out (physically) so I can ... to be a DESCRIBE for SQL Server See Question&Answers more detail:os...

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

0 votes

446 views

1 answer

sql server 2008 - query optimizer operator choice - nested loops vs hash match (or merge)

One of my stored procedures was taking too long execute. Taking a look at query execution plan I was able to ... loops in this scenario? Thanks See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags