Recent questions tagged SQL

0 votes

267 views

1 answer

sql server - How Can I Detect and Bound Changes Between Row Values in a SQL Table?

I have a table which records values over time, similar to the following: RecordId Time Name =========== ... this (preferrably without a cursor?) See Question&Answers more detail:os...

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

0 votes

879 views

1 answer

sql - Group DateTime into 5,15,30 and 60 minute intervals

I am trying to group some records into 5-, 15-, 30- and 60-minute intervals: SELECT AVG(value) as " ... column. Any help is much appreciated! See Question&Answers more detail:os...

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

0 votes

308 views

1 answer

sql - Postgres not using index when index scan is much better option

I have a simple query to join two tables that's being really slow. I found out that the query plan ... ~10m rows email_recipients: ~11m rows See Question&Answers more detail:os...

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

0 votes

380 views

1 answer

sql - Solution to "cannot perform a DML operation inside a query"?

I am using a Data Analysis tool and the requirement I have was to accept a value from the user, pass that ... why it is illegal/not recommended See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql - Why don't DBMS's support ASSERTION

So I recently learned about ASSERTION in my databases course, and my prof noted that major databases don't ... with triggers or anything else. See Question&Answers more detail:os...

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

0 votes

550 views

1 answer

sql - MySQL bulk INSERT or UPDATE

Is there any way of performing in bulk a query like INSERT OR UPDATE on the MySQL server? INSERT IGNORE ... won' ... one row at the same time). See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - In Oracle, is it possible to INSERT or UPDATE a record through a view?

In Oracle, is it possible to INSERT or UPDATE a record (a row) through a view? See Question&Answers more detail:os...

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

0 votes

364 views

1 answer

sql - How do I start auto increment from a specific point?

CREATE TABLE `batchinfo` ( `rowid` int(11) NOT NULL AUTO_INCREMENT, `datapath` mediumtext, `analysistime` ... start incrementing from 20000? See Question&Answers more detail:os...

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

0 votes

422 views

1 answer

sql - Get AVG ignoring Null or Zero values

How can I get the AVG of a column ignoring NULL and zero values? I have three columns to get their ... ? example: AVERAGE(NOTNULL(SecurityW)) See Question&Answers more detail:os...

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

0 votes

669 views

1 answer

sql - Solution to "cannot perform a DML operation inside a query"?

I am using a Data Analysis tool and the requirement I have was to accept a value from the user, pass that ... why it is illegal/not recommended See Question&Answers more detail:os...

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

0 votes

287 views

1 answer

sql - Why don't DBMS's support ASSERTION

So I recently learned about ASSERTION in my databases course, and my prof noted that major databases don't ... with triggers or anything else. See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql - MySQL bulk INSERT or UPDATE

Is there any way of performing in bulk a query like INSERT OR UPDATE on the MySQL server? INSERT IGNORE ... won' ... one row at the same time). See Question&Answers more detail:os...

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

0 votes

305 views

1 answer

sql - In Oracle, is it possible to INSERT or UPDATE a record through a view?

In Oracle, is it possible to INSERT or UPDATE a record (a row) through a view? See Question&Answers more detail:os...

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

0 votes

354 views

1 answer

sql - How do I start auto increment from a specific point?

CREATE TABLE `batchinfo` ( `rowid` int(11) NOT NULL AUTO_INCREMENT, `datapath` mediumtext, `analysistime` ... start incrementing from 20000? See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

sql - Get AVG ignoring Null or Zero values

How can I get the AVG of a column ignoring NULL and zero values? I have three columns to get their ... ? example: AVERAGE(NOTNULL(SecurityW)) See Question&Answers more detail:os...

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

0 votes

452 views

1 answer

sql - How to use the LIMIT argument in an SQLite Query with Android

I am trying to use the following query to get the most recent result by date. Cursor cursor = mDb.query( ... TEST ORDER BY dateDESC LIMIT 1 See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql server - T-SQL Conditional Order By

I am trying to write a stored procedure that returns a list of object with the sort order and sort direction ... . Anyone got any suggestions? See Question&Answers more detail:os...

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

0 votes

549 views

1 answer

sql - Get count of records affected by INSERT or UPDATE in PostgreSQL

My database driver for PostgreSQL 8/9 does not return a count of records affected when executing INSERT or UPDATE ... Widgets') RETURNING did; See Question&Answers more detail:os...

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

0 votes

652 views

1 answer

sql - ORA-00972 identifier is too long alias column name

i have a query like : SELECT column as averyveryveryverylongalias (more than 30 characters) FROM Table_name it ... the alias shorter? Thanks See Question&Answers more detail:os...

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

0 votes

451 views

1 answer

sql server - How to automatically generate unique id in SQL like UID12345678?

I want to automatically generate unique id with per-defined code attach to it. ex: UID12345678 CUSID5000 I tried ... . Any one have suggestions? See Question&Answers more detail:os...

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

0 votes

350 views

1 answer

sql server - Sql query for tree table

I have a table with tree structure: id parentId name ---------------- 1 0 Category1 2 0 Category2 3 1 ... help me to write ms-sql query? Thanks! See Question&Answers more detail:os...

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

0 votes

297 views

1 answer

sql server - Sql query for tree table

I have a table with tree structure: id parentId name ---------------- 1 0 Category1 2 0 Category2 3 1 ... help me to write ms-sql query? Thanks! See Question&Answers more detail:os...

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

0 votes

332 views

1 answer

sql - How can I use SUM() OVER()

I can't understand this code's bug ID AccountID Quantity 1 1 10 Sum = 10 2 1 5 = 10 + 5 = 15 ... BY AccountID ) AS TopBorcT, FROM tCariH See Question&Answers more detail:os...

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

0 votes

396 views

1 answer

sql server - How can I get the list of tables in the stored procedure?

There are lot of tables and sp in the db. I find the tables name which are used in the specific sp (stored ... is not full fill my requirment. See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql - Query times out from web app but runs fine from management studio

This is a question I asked on another forum which received some decent answers, but I wanted to see if anyone ... apply to any RDBMS system. See Question&Answers more detail:os...

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

0 votes

260 views

1 answer

sql - Update a column of a table with a column of another table in PostgreSQL

I want to copy all the values from one column val1 of a table table1 to one column val2 of another table ... there an alternative to do that? See Question&Answers more detail:os...

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

0 votes

468 views

1 answer

sql - How do I speed up counting rows in a PostgreSQL table?

We need to count the number of rows in a PostgreSQL table. In our case, no conditions need to be met ... that implies not getting exact results. See Question&Answers more detail:os...

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

0 votes

498 views

1 answer

sql - How to count the number of occurrences of a character in an Oracle varchar value?

How can I count number of occurrences of the character - in a varchar2 string? Example: select XXX('123-345-566', '-') from ... -------------- 2 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags