Recent questions tagged SQL

0 votes

560 views

1 answer

sql - How to compare dates in datetime fields in Postgresql?

I have been facing a strange scenario when comparing dates in postgresql(version 9.2.4 in windows). I have a ... working but not the first one? See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

sql - skip copying to tmp table on disk mysql

I have a question for large mysql queries. Is it possible to skip the copying to tmp table on disk step that ... are slow. Any help? Thank you See Question&Answers more detail:os...

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

0 votes

277 views

1 answer

sql - Can you create nested WITH clauses for Common Table Expressions?

WITH y AS ( WITH x AS ( SELECT * FROM MyTable ) SELECT * FROM x ) SELECT * FROM y Does something like this ... but I couldn't get it to work. See Question&Answers more detail:os...

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

0 votes

546 views

1 answer

sql - COUNT DISTINCT with CONDITIONS

I want to count the number of distinct items in a column subject to a certain condition, for example if the ... way to solve this problem. See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql update - Change One Cell's Data in mysql

How can I change the data in only one cell of a mysql table. I have problem with UPDATE because it makes all ... I want only one changed. How? See Question&Answers more detail:os...

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

0 votes

354 views

1 answer

sql - GRANT EXECUTE to all stored procedures

Does the following command effectively give the user, "MyUser," permission to execute ALL stored procedures in ... EXECUTE TO [MyDomainMyUser] See Question&Answers more detail:os...

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

0 votes

361 views

1 answer

sql server - Change Schema Name Of Table In SQL

I want to change schema name of table Employees in Database. In the current table Employees database schema name is ... . What did I miss? See Question&Answers more detail:os...

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

0 votes

361 views

1 answer

sql - How to detect query which holds the lock in Postgres?

I want to track mutual locks in postgres constantly. I came across Locks Monitoring article and tried to run ... blocker queries. Any ideas? See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - ERROR: permission denied for sequence cities_id_seq using Postgres

I'm new at postgres (and at database info systems all in all). I ran following sql script on my database: ... my problem. What am I missing? See Question&Answers more detail:os...

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

0 votes

401 views

1 answer

sql - Why historically do people use 255 not 256 for database field magnitudes?

You often see database fields set to have a magnitude of 255 characters, what is the traditional / historic reason ... must have been new once. See Question&Answers more detail:os...

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

0 votes

363 views

1 answer

sql - List all tables in postgresql information_schema

What is the best way to list all of the tables within PostgreSQL's information_schema? To clarify: I ... in the information_schema structure. See Question&Answers more detail:os...

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

0 votes

261 views

1 answer

sql server - How to drop all tables from a database with one SQL query?

I don't want to type all tables' name to drop all of them. Is it possible with one query? See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

sql - How to find duplicate records in PostgreSQL

I have a PostgreSQL database table called "user_links" which currently allows the following duplicate fields: year, ... to find all duplicates? See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql server - Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed? See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql - "pivot" table Oracle - how to change row items into columns

I have the following simple example: CREATE TABLE Cars ( Cars, Item, Value ) AS SELECT 'bmw', 'wheels' ... lead to real performance problems. See Question&Answers more detail:os...

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

0 votes

330 views

1 answer

sql - How to sync a mysql database to external data source

I have a mysql database table called search that I need to keep up to data with an ElasticSearch index. I ... have read-access to the database. See Question&Answers more detail:os...

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

0 votes

347 views

1 answer

sql server - insert XML file in SQL via SSIS

I have this procedure ALTER proc [dbo].[adenti] ( @entra nvarchar(max) ) as DECLARE @sql varchar(4000); SET @sql ... a path into a SQL table? See Question&Answers more detail:os...

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

0 votes

276 views

1 answer

sql - Sqlite Database Load Fails - Issue with sqlite prepare statement - iPhone - xCode 4.3.1

I am having issues with the following code which loads an SQLite database. - (NSArray *)getDatabase { NSLog(@" ... problem ? Thank in advance. See Question&Answers more detail:os...

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

0 votes

310 views

1 answer

sql - It's possible to create a rule in preceding rows in sum?

I have a historical stock variation values and have to calculate the stock value. But I also have a rule that the stock is ... | |-0.4 |-7.62| See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

sql - How to convert Unix epoch to a timestamp

I am new to postgresql bot not to sql in general. I have a table that I need to read values from, on of ... me. Postgresql 9.5 is the database. See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql - Return a grouped list with occurrences using Rails and PostgreSQL

I have a list of Tags in my rails application which are linked to Posts using Taggings. In some views, I'd like ... and display it to the user? See Question&Answers more detail:os...

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

0 votes

265 views

1 answer

sql - Generate a unique column sequence value based on a query handling concurrency

I have a requirement to automatically generate a column's value based on another query's result. Because ... between @MonthStart and @MonthEnd; See Question&Answers more detail:os...

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

0 votes

323 views

1 answer

sql server - Fetch scope_identity value in C# code from stored procedure in 3 tier architecture

I need to fetch scope_identity() value from a stored procedure after inserting data in C# code. Here I am using 3 ... in C# code. Anyone help? See Question&Answers more detail:os...

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

0 votes

291 views

1 answer

sql - join two dataframes on common column

I want to join two data sources, orders and customers: orders is an SQL Server table: orderid| customerid | ... fine. Any help? Thanks. See Question&Answers more detail:os...

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

0 votes

352 views

1 answer

sql - Unable to understand how value converted to date format implicitly

As I checked my NLS_DATE_FORMAT is DD-MM-RR. Considering mytable with a date column,when I execute the ... implicit conversion is taking place? See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

sql - Find the referenced table name using table, field and schema name

I have a requirement where I need to find the referenced table name (Primary key table name) by a particular field ... I am using Postgres 8.3. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - using AS to avoid same query mySQL

I am trying to get the IDs of half of the good players, but only those contained in node_id=28 " SELECT * ... selectedPlayers) / 2' at line 10' See Question&Answers more detail:os...

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

0 votes

348 views

1 answer

sql - percentiles from histogram data

The following table captures student grade data over a number of exams. CREATE TABLE grades AS SELECT name, ... percentile would be grade_fair. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags