Recent questions tagged SQL

0 votes

328 views

1 answer

sql - MySQL: Compare differences between two tables

Same as oracle diff: how to compare two tables? except in mysql. Suppose I have two tables, t1 and t2 which are ... if that might be a factor. See Question&Answers more detail:os...

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

0 votes

399 views

1 answer

sql server - SQL "between" not inclusive

I have a query like this: SELECT * FROM Cases WHERE created_at BETWEEN '2013-05-01' AND '2013-05-01' But this ... ) work with a single date too. See Question&Answers more detail:os...

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

0 votes

315 views

1 answer

sql - How to Select Every Row Where Column Value is NOT Distinct

I need to run a select statement that returns all rows where the value of a column is not distinct (e.g. ... COUNT(distinct(EmailAddress)) > 1 See Question&Answers more detail:os...

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

0 votes

322 views

1 answer

sql server - SELECT INTO a table variable in T-SQL

Got a complex SELECT query, from which I would like to insert all rows into a table variable, but T-SQL doesn't ... if I'm doing it all wrong. See Question&Answers more detail:os...

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

0 votes

479 views

1 answer

sql server - Database design: Calculating the Account Balance

How do I design the database to calculate the account balance? 1) Currently I calculate the account balance from ... Amount $200, Balance $240. See Question&Answers more detail:os...

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

0 votes

365 views

1 answer

sql - How to do an INNER JOIN on multiple columns

I'm working on a homework project and I'm supposed to perform a database query which finds flights either ... how to construct SQL statements! See Question&Answers more detail:os...

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

0 votes

400 views

1 answer

sql - How to find third or n?? maximum salary from salary table?

How to find third or nth maximum salary from salary table(EmpID, EmpName, EmpSalary) in optimized way? See Question&Answers more detail:os...

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

0 votes

342 views

1 answer

sql - What is Full Text Search vs LIKE

I just read a post mentioning "full text search" in SQL. I was just wondering what the difference between ... anything that explained it well. See Question&Answers more detail:os...

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

0 votes

373 views

1 answer

sql - Find rows that have the same value on a column in MySQL

In a [member] table, some rows have the same value for the email column. login_id | email ---------|----- ... use to find these rows? (MySQL 5) See Question&Answers more detail:os...

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

0 votes

331 views

1 answer

sql - How to exclude rows that don't join with another table?

I have two tables, one has primary key other has it as a foreign key. I want to pull data from the primary ... that join together by that key. See Question&Answers more detail:os...

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

0 votes

337 views

1 answer

sql - Skip certain tables with mysqldump

Is there a way to restrict certain tables from the mysqldump command? For example, I'd use the following syntax to ... ) the only way to go? See Question&Answers more detail:os...

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

0 votes

299 views

1 answer

sql - Foreign Key Not Populating with Primary Key Values

I have searched for an answer but am not finding it. I have 2 tables. Both have an auto-generated PK. The ... null when I query table 1? See Question&Answers more detail:os...

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

0 votes

266 views

1 answer

sql server - SQL Recursive CTE: Finding objects linked by property

I'm just trying to understand CTE and recursion to solve an issue that I would previously have used a cursor for ... What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

318 views

1 answer

sql - Postgresql Column Not Found, But Shows in Describe

There have been similar posts, but none helped me solve my problem. I am trying to do a simple select on a ... why I would receive this error? See Question&Answers more detail:os...

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

0 votes

311 views

1 answer

sql - Foreign Key Creation issue in Oracle

When I try to create these two tables I get: "SQL Error: ORA-00904: "COLLECTIBLENUM": invalid ... ) REFERENCES Collectibles(CollectibleNum)); See Question&Answers more detail:os...

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

0 votes

491 views

1 answer

sql - ORACLE After update trigger: solving ORA-04091 mutating table error

I am trying to create a trigger: create or replace trigger NAME_OF_TRIGGER after insert or update on table1 ... or an autonomous transaction? See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sql - Reference alias in WHERE clause

In psql, trying to reference alias in WHERE clause: SELECT SUBSTRING(pk, 6, 2)::INT AS _year FROM listing ... reference alias in WHERE clause? See Question&Answers more detail:os...

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

0 votes

355 views

1 answer

sql - Concatenate grouped rows

I would like to know is it possible from this table ID Price ServiceID 1 50 11 1 -10 12 2 100 11 ... troubling me. Thank you for participating. See Question&Answers more detail:os...

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

0 votes

293 views

1 answer

sql - MySQL Stored Procedures not working with SELECT (basic question)

I am using a platform (perfectforms) that requires me to use stored procedures for most of my queries, and ... Any help is greatly appreciated. See Question&Answers more detail:os...

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

0 votes

319 views

1 answer

sql - How to resolve SQL0418N Error

I'm using the statement below to update/insert some data to a table and, if I run it without parameters, it ... Thanks in advance for the help! See Question&Answers more detail:os...

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

0 votes

349 views

1 answer

sql - How to correctly insert newline in nvarchar

I need to make a script that takes some rich text (html text) and transform it to regular text. What I want ... Any idea what I am doing wrong? See Question&Answers more detail:os...

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

0 votes

486 views

1 answer

sql - unpivot with dynamic columns plus column names

I'm trying to unpivot a table with a large number of columns in the format of: PID UID col1 col2 col3... ... into the output of the unpivot. See Question&Answers more detail:os...

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

0 votes

258 views

1 answer

sql server - displaying multiple records by using resultset

how to display multiple records from database having the same field value by using result set statement See Question&Answers more detail:os...

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

0 votes

246 views

1 answer

sql server - Get the character between first 2 special character in SQL

I have data in sql (Just to note: SQL STudio is the IDE) like: data a_10_b_c a_1_b_c I want to get the data ... first two symbols _: Output 10 1 See Question&Answers more detail:os...

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

0 votes

282 views

1 answer

sql - Advice Using Pivot Table in Oracle

i need a report and i should use pivot table for it.Report will be group by categories .It is not good ... except for using case when? Thanks See Question&Answers more detail:os...

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

0 votes

394 views

1 answer

sql - OPENXML with xmlns:dt

Use OPENXML to get dt element in MSSQL 2005. How can I get xmlns:dt element in xml? For ... sp_xml_removedocument @hDoc DROP TABLE #xmlEdgeTable See Question&Answers more detail:os...

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

0 votes

237 views

1 answer

sql - Access - compare two tables and update or insert data in first table

In my Access datebase I have a two tables: Table1: PersNum Name Surname 2321 Lenora Springer 2320 Donya Gugino 3326 ... on SQL/VBA/DAO/ADO. See Question&Answers more detail:os...

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

0 votes

281 views

1 answer

sql - PHP/MySQL Pagination

I am new to php and sql, and i have one tiny question about how to realize sql query , that can: Take for example ... ) and so on :) Thank you ) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags