Recent questions tagged SQl

0 votes

200 views

1 answer

sql - is of a type that is invalid for use as a key column in an index

I have an error at Column 'key' in table 'misc_info' is of a type that is invalid for use as a key column ... [value] nvarchar(max) NOT NULL); See Question&Answers more detail:os...

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

0 votes

229 views

1 answer

sql - Core Data Performance with Single Parent Entity

I am creating a framework that works with Core Data. One of the requirements for using my framework on ... would be highly appreciated. See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table

Let's say we have table Sales with 30 columns and 500,000 rows. I would like to delete 400,000 ... partitioned & possibly transaction log free. See Question&Answers more detail:os...

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

0 votes

379 views

1 answer

sql - MySQL: GROUP_CONCAT with LEFT JOIN

I'm experiencing a problem with MySQL's "GROUP_CONCAT" function. I will illustrate my problem using a simple help ... am I doing wrong? Thanks! See Question&Answers more detail:os...

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

0 votes

225 views

1 answer

sql - mysql update query with sub query

Can anyone see what is wrong with the below query? When I run it I get: #1064 - You have ... where a.CompetitionID = Competition.CompetitionID See Question&Answers more detail:os...

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

0 votes

219 views

1 answer

sql server - How to group by month from Date field using sql

How can I group only by month from a date field (and not group by day)? Here is what my date field ... not null group by Closing_Date, Category See Question&Answers more detail:os...

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

0 votes

233 views

1 answer

sql server - SQL performance: WHERE vs WHERE(ROW_NUMBER)

I want get n-th to m-th records in a table, what's best choice in 2 below solutions: Solution 1: SELECT * FROM ... WHERE row >= n AND row <= m See Question&Answers more detail:os...

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

0 votes

404 views

1 answer

sql - Fetch a single record from table using list comprehension in python?

def fetch_maxno(): dsn_tns = cx_Oracle.makedsn('host', 'port', service_name='serviceno') connection = cx_Oracle.connect(user=' ... guide me is there any other way to get this....

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

0 votes

455 views

1 answer

sql - Postgres query with limit that selects all records with similar identifier

I have a table that looks something like this: customer_id data 1 123 1 456 2 789 2 101 2 121 2 123 3 123 4 456...

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

0 votes

347 views

1 answer

sql - Update query statement

I found out something strange which works Update **X** SET field = 'bla' from **X** ..which doesn't really make sense...

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

0 votes

999 views

1 answer

sql server - Can't connect to database using JDBC (Communications link failure) despite being able to connect by other means

I am running MSSQL on docker using port 1433: And am able to connect to it and make queries using a simple tool ... I wonder what could be causing the problem. Thanks in advance....

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

0 votes

386 views

1 answer

sql - SSAS force aggregation of the results of calculated measure

I have a calculated measure in SSAS cube used in excel pivot table. My issue is that the calculated measure treats totals as ... 1 2880 product8 1 872 0 0 product9 2 1680 0 0...

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

0 votes

385 views

1 answer

sql - How to get the data of the newly accessed record by a query on PostgreSQL using it's internal variables and functions?

Let's say I have the following 'items' table in my PostgreSQL database: id item value 1 a 10 2 b 20 3 c 30...

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

0 votes

507 views

1 answer

sql - MySQL 5.7, sort table by column name using a variable in Stored procedure

I have a simple table with some data: DROP TABLE IF EXISTS `MY_TABLE`; CREATE TABLE IF NOT EXISTS `MY_TABLE` ( ` ... as I'm passing the string with a minus prepended: -columnAlias....

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

Categories

Just Browsing Browsing

Most popular tags