Recent questions tagged SQL

0 votes

530 views

1 answer

sql - Splitting comma separated values in Oracle

I have column in my database where the values are coming like the following: 3862,3654,3828 In dummy column ... problem. Can anyone can help? See Question&Answers more detail:os...

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

0 votes

289 views

1 answer

sql server - Alphanumeric Sort

I need quick help in sorting data at SQL side. I am using Sqlserver 2012 (good if answer give with the ... test1 test1 test11 test2 test2 test11 See Question&Answers more detail:os...

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

0 votes

502 views

1 answer

sql - How get information from multiple tables using cursor?

I have a query, that returns multiple tables, something like that: SELECT TableName, DatabaseName +'.'+ ... addition? DBMS is Teradata See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql - Retrieve 2 last posts for each category

Lets say I have 2 tables: blog_posts and categories. Each blog post belongs to only ONE category, so there is ... whom can help me with this. See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql - Mysql - How do I order results by alternating (1,2,3, 1, 2, 3, 1, 2, 3,) rows, is it possible?

I want to order my results by client 1, 2, 3, then again client 1, 2, 3, and so on. Is there a ... 2 29 project orange 3 21 project banana See Question&Answers more detail:os...

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

0 votes

358 views

1 answer

sql - How do I query all rows within a 5-mile radius of my coordinates?

Here's a sample of my PostgreSQL in CSV format. row,latitude,longitude 1,42.082513,-72.621498 2,42.058588 ... this with PostGIS and PostgreSQL? See Question&Answers more detail:os...

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

0 votes

328 views

1 answer

sql server convert datetime into another timezone?

How do I convert the current time (datetime) in my timezone into another timezone, say France ? I looked around ... I am using SQL server 2008. See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - MySQL Duplicate rows

I have a table with some repeated information: Id, Name, Lastname, Birth, PersonalKey, Personal Info, Direction, ... value). Thanks in advance. See Question&Answers more detail:os...

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

0 votes

445 views

1 answer

sql server - Why Error: "[ODBC Driver Manager] Data source name not found..."? (works fine on dev environment)

I'm encountering problems in my ASP page. This is a login page which checks the user's credentials to ... be greatly accepted. Thanks, Nhoyti See Question&Answers more detail:os...

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

0 votes

381 views

1 answer

sql - Simplify nested case when statement

Below is my current SELECT CASE statement: SELECT CASE WHEN edition = 'STAN' AND has9 = 1 THEN '9' WHEN ... can I compile that in PostgreSQL? See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - Access top n in group

I have a table where I need to get the top n highest amount items for each Category. Category Item ... Utensil fork 7 Utensil spork 4 See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql update - Updating Views in MySQL

I am creating a view to show the user his/her data, but I also want the user to be able to make changes in ... up of more than one base table? See Question&Answers more detail:os...

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

0 votes

473 views

1 answer

sql server - Return a value and a result set from stored procedure classic asp

I want to get both a return code and a result set back from a stored procedure in classic ASP. CREATE PROCEDURE ... there a way to get both? See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

sql - PostgreSQL - Replace HTML Entities

I have just set about the task of stripping out HTML entities from our database, as we do a lot of crawling and ... only be 40 or so of them. See Question&Answers more detail:os...

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

0 votes

707 views

1 answer

sql - Calculate missing date ranges and overlapping date ranges between two dates

I have the following set of dates (dd/MM/yyyy) matching events in my database: eventId startDate endDate 1 02/05/2009 ... 30/06/2009 23:59:59. See Question&Answers more detail:os...

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

0 votes

441 views

1 answer

sql - Why is my CASE expression non-deterministic?

I am trying to create a persisted computed column using CASE expression: ALTER TABLE dbo.Calendar ADD PreviousDate ... service pack. Thanks. See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql - Distinct LISTAGG that is inside a subquery in the SELECT list

Here is a minimal working example of what I'm trying to do and what I'm getting: I have a query as ... tried. Any help will be appreciated. See Question&Answers more detail:os...

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

0 votes

353 views

1 answer

sql - How can I do a contiguous group by in MySQL?

How can I return what would effectively be a "contiguous" GROUP BY in MySQL. In other words a GROUP BY that respects the ... a 2 3 b 2 5 a 2 See Question&Answers more detail:os...

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

0 votes

317 views

1 answer

sql - Having TRANSACTION In All Queries

Do you think always having a transaction around the SQL statements in a stored procedure is a good practice? I'm ... Thanks for your time, guys. See Question&Answers more detail:os...

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

0 votes

385 views

1 answer

sql - ActiveRecord Find - Skipping Records or Getting Every Nth Record

I'd like to do a query where I select a bunch of data, but I'd like to be able to then ... straightforward way to do this with ActiveRecord? See Question&Answers more detail:os...

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

0 votes

522 views

1 answer

sql - RODBC sqlQuery() returns varchar(255) when it should return varchar(MAX)

I am using the RODBC package to query a text column from a database. The database is built on Microsoft SQL Server ... do I avoid it? Thanks!! See Question&Answers more detail:os...

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

0 votes

516 views

1 answer

sql server - SQL: Count distinct values from one column based on multiple criteria in other columns

I am trying to do count distinct values based on multiple criteria. Sample data exercise included below. Table1 ... help is greatly appreciated. See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql order by - Sort MySQL results alphabetically, but with numbers last

Often, sorting is done with symbols sorted to the top, like 0 or * or &. This is the default way that ... ? Something in the ORDER BY clause? See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql server - How to Short-Circuit SQL Where Clause

I am trying to perform the following query in SQL server: declare @queryWord as nvarchar(20) = 'asdas' SELECT * ... that SQL already did this. See Question&Answers more detail:os...

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

0 votes

313 views

1 answer

sql server - Clustered indexes on non-identity columns to speed up bulk inserts?

My two questions are: Can I use clustered indexes to speed up bulk inserts in big tables? Can I then ... for any suggestions or explanations. See Question&Answers more detail:os...

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

0 votes

292 views

1 answer

sql server - Sql aggregate function to obtain a list

Hei! How can I create an aggregate function to obtain a list of the aggregate values. given : key value Andrei 1 Andrei 2 ... 1,2,3 Mihai 4,5,6 See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

sql - Workaround for ORA-00997: illegal use of LONG datatype

I want to save some data from a system table user_tab_cols, to a temp table so I can take a dump from it. ... a long type into another table? See Question&Answers more detail:os...

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

0 votes

392 views

1 answer

sql - Check statistics targets in PostgreSQL

I have searched but been unable to find any simple, straight forward answer to this. How do I check the ... statistics targets used by ANALYZE? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags