Recent questions tagged SQL

0 votes

391 views

1 answer

sql - Trouble making a running sum in Access query

I'm stuck trying to get a running sum to work in an Access query. I've been playing around with various ... running sum? Thanks for the help! See Question&Answers more detail:os...

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

0 votes

403 views

1 answer

sql - MS Access: setting table column Caption or Description in DDL?

Is it possible to set a table column's Caption or Description properties in MS Access using DDL? Ideally, we ... in a CREATE TABLE statement. See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - Connect to web-service/API in MySQL?

I'm creating a sql based procedure which can Accept a table load the values one at a time send the variables ... if you have any suggestions! See Question&Answers more detail:os...

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

0 votes

406 views

1 answer

sql - Oracle TOP N ordered rows

I would like to get the top N rows from an Oracle table sorted by date. The common way to do this, ... ORDERED rows returned in the subquery ? See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql - Delete records which are considered duplicates based on same value on a column and keep the newest

I would like to delete records which are considered duplicates based on them having the same value in a certain column ... 07/06/2009', 'John6' See Question&Answers more detail:os...

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

0 votes

569 views

1 answer

sql server - Oracle provider for Oledb missing in VS 2015 Shell

I am migrating to SSIS 2016 version. I am trying to use the Oracle provider for Oledb in connections. However, this ... shown. How to fix this? See Question&Answers more detail:os...

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

0 votes

448 views

1 answer

sql - issue with to_date function with sysdate

I saw this question so I've one doubt regarding this question: I am getting different result with the same ... tuesday why does this happened? See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

sql server - Getting top n to n rows from db2

I need to split a huge table in to chunks. Fetching data from DB2 and processing in SSIS iteration 1 : Get ... tablename fetch 10 to 20 rows See Question&Answers more detail:os...

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

0 votes

334 views

1 answer

sql - MySql view is very slow. Why?

My normal query: SELECT DISTINCT vt.id as id, vtt.name as n, vt.etxid as etx FROM vt LEFT JOIN vtt ON ... * from myview; Execution time: 600ms See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql - Convert day of the year to a date in java

I have a number of day of the year. (Today's number of the day is 308.) I want to convert this number to ... it in java? Thank you in advance. See Question&Answers more detail:os...

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

0 votes

303 views

1 answer

sql - Change number column

I have NAME and PAY, but I need CHANGEGROUP in this example: NAME PAY DATE CHANGEGROUP Sally 12 10/01/2011 1 ... this older version of SQL 2005 See Question&Answers more detail:os...

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

0 votes

290 views

1 answer

sql - how to select all data whose input array found and not found in mysql

CREATE TABLE emp ( empno decimal(4,0) NOT NULL, ename varchar(10) default NULL, job varchar(9) default NULL, ... 7369|SMITH,7499|ALLEN,null|TOM See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - pgAdmin4: Importing a CSV

I am trying to import a CSV using pgAdmin4. I created the table using the query, CREATE TABLE i210_2017_02_18 ( PROBE_ID ... to me - any ideas? See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

sql - Complex sort of field "string - number - string"

Basically, I am trying to sort a table by its name. The table is relatively big, but I am posting only one ... the stations goes on after EPA. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - Listagg alternative in db2

My customer is using db2 database without listagg function, but I need to somehow aggregate the primary key ... Thanks for the responses. See Question&Answers more detail:os...

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

0 votes

503 views

1 answer

sql - Performance tuning on INNER JOIN with BETWEEN Condition

I have two table's namely tbl_Small and tbl_Large. Both the table's I have stored in Microsoft Azure and ... 5 min DTU Percentage graph: See Question&Answers more detail:os...

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

0 votes

421 views

1 answer

sql - Oracle Combine several columns into one

I have a question in regarding to Oracle Sql, If I have a data called A, with 8 columns: Spot| ID |Sunday| ... How can I do that please? Thanks! See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql - Check Constraints in Access

I'm working on an Access database, and I want to save a Check Constraint as a query. Is that even possible in ... it doesn't work in Access.. See Question&Answers more detail:os...

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

0 votes

447 views

1 answer

sql server 2008 - having problems trying to restore encrypted database

Im trying to copy an encrypted database from the default server to my server for testing purposes but im having ... in advance for ur time See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql - dynamic table name in select statement

I have a series of history tables in an oracle 9 database. History_table_00 contains last months data, ... you guys can provide. See Question&Answers more detail:os...

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

0 votes

262 views

1 answer

sql - customer.pk_name joining transactions.fk_name vs. customer.pk_id [serial] joining transactions.fk_id [integer]

Pawnshop Application (any RDBMS): one-to-many relationship where each customer (master) can have many transactions ( ... have a large table. See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql server regex

In SQL Server (2012) I have a field with numeric values. The field is of type int. Let's say that the field ... working. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

450 views

1 answer

sql - Type equality test w/ decltype(), auto, or RTTI in C++? Does Boost have something for this?

I'm writing some code to translate a C++ type to an appropriate type for a SQL DB. I want to identify the ... time for any input you may have. See Question&Answers more detail:os...

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

0 votes

338 views

1 answer

sql - how to display number value in words

Q. Display the number value in Words and output should look like this SAL In_Words --------- -------- ... have any idea about this query ? See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

sql - pyodbc execute command not accepting ? parameters correctly?

This code: cursor.execute('select RLAMBD from ?', OPTable) print cursor.fetchone().RLAMBD produces this error: ... and pyodbc 3.0.10. See Question&Answers more detail:os...

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

0 votes

387 views

1 answer

sql - mysql Event running yearly calculations

I have the following code CREATE EVENT myevent2 ON SCHEDULE EVERY '1' YEAR STARTS commit_date + INTERVAL 1 YEAR DO ... current date to be 1 year See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

sql - Insert multiple records in oracle

I am using oracle sql developer to insert rows in my database. While this request is working : INSERT INTO ... "SQL command not properly ended" See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

sql server - The database 'xxx' cannot be opened because it is version 904

I can't attach my database. When I try to attach a database in SQL Server Management Studio, I get this error: ... " but it still has an error See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags