Recent questions tagged SQL

0 votes

352 views

1 answer

sql - To prevent the use of duplicate Tags in a database

I would like to know how you can prevent to use of two same tags in a database table. One said me that ... use of duplicate tags in a question? See Question&Answers more detail:os...

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

0 votes

393 views

1 answer

sql - Adding a Row Number in Query

I have a table in my database in Access 2013. Table : city ID_city city 1 Tetuan 5 Rabat 9 Marrakech 10 ... Marrakech 4 10 Agadir 5 15 Laayoun See Question&Answers more detail:os...

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

0 votes

495 views

1 answer

sql - Interview - Detect/remove duplicate entries

how to detect/remove duplicate entries from a database in a table where there is no primary key ? [If we use ... one and duplicate one ? ] See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

sql - Hibernate Create Criteria to join the same table twice - tried 2 approach with 2 difference error

I would like to create create criteria for the following native sql. Unfortunately, I hit error of duplicate ... Appreciate your help. Thanks. See Question&Answers more detail:os...

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

0 votes

398 views

1 answer

sql - Getting a rank from ActiveRecord

If Users have points, how can I get the user rank, assuming standard positioning: require 'active_record' class ... succinct? Thanks in advance See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql - Is it possible to use a returned column value as a table name in an SQLite query?

I want to write a query that examines all the tables in an SQLite database for a piece of information in order ... is it simply not supported? See Question&Answers more detail:os...

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

0 votes

410 views

1 answer

sql - Like operation returns no rows on nvarchar column filter if the column data start with numeric

I have nvarchar(50) column in SQL Server table and data like this: 123abc 234abc 456abc My query: select * ... type is nvarchar. Any ideas? See Question&Answers more detail:os...

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

0 votes

472 views

1 answer

sql - Credentials Error when integrating Google Drive with

I am using Google Big Query, I want to integrate Google Big Query to Google Drive. In Big query I am ... Contact the table owner for assistance. See Question&Answers more detail:os...

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

0 votes

375 views

1 answer

sql - Is it true that using INNER JOIN after any OUTER JOIN will essentially invalidate the effects of OUTER JOIN?

In other words, for a nested/multiple JOIN SQL statement, is it safe to say that one should always use INNER ... be extremely rare, I guess) See Question&Answers more detail:os...

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

0 votes

436 views

1 answer

sql server - Dynamically Retrieve Parameter Names & Current Values Inside T-SQL Stored Procedure

I have hundreds of templated ETL stored procedures for Business Intelligence. They log their operational activity to ... any pointers! - Tim See Question&Answers more detail:os...

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

0 votes

587 views

1 answer

sql server - java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver : Am I loading the right driver?

When I run the following snippet to connect to datasource to get the data out through queries : try { ... following snapshot tells this : See Question&Answers more detail:os...

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

0 votes

341 views

1 answer

sql - Allow only 3 rows to be added to a table for a specific value

I have a question in hand where i need to restrict the number of projects assigned to a manager to only 3 ... to take to implement this? See Question&Answers more detail:os...

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

0 votes

459 views

1 answer

sql - Date calculation with parameter in SSIS is not giving the correct result

I want to load data from the last n days from a data source. To do this, I have a project parameter " ... , or am I missing something here? See Question&Answers more detail:os...

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

0 votes

370 views

1 answer

sql - Why my table doesnt support FOREIGN KEYS?

I have made a database and 10 tables in mysql(table type NONE) and i can't create foreign keys. An alert ... ? thanks for any hint or suggestion See Question&Answers more detail:os...

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

0 votes

374 views

1 answer

sql join syntax

I'm kind of new to writing sql and I have a question about joins. Here's an example select: select bb.name ... I'm having trouble googling it. See Question&Answers more detail:os...

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

0 votes

488 views

1 answer

sql - MySQL limit results per category

Each item in c_data is in a category/section. I would like to limit how many items are displayed per category, ... the category is "sectionid". See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

sql - SSIS - Performing a Lookup on another Table to get Related Column

I want to executing a select statement in SSIS, but this select statement takes a parameter from another component, and ... on how to do it? See Question&Answers more detail:os...

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

0 votes

722 views

1 answer

sql - ORA-00907: missing right parenthesis

CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), PRIMARY ... -00907: missing right parenthesis See Question&Answers more detail:os...

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

0 votes

417 views

1 answer

sql - Find most common elements in array with a group by

I have a table of rows with the following structure name TEXT, favorite_colors TEXT[], group_name INTEGER where each ... else to count and rank? See Question&Answers more detail:os...

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

0 votes

413 views

1 answer

sql - dba_jobs_running: table or view does not exist when trying to access from procedure

Simply querying running jobs using something like select * from dba_jobs_running; works fine when executed in my ... thanks in advance :) See Question&Answers more detail:os...

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

0 votes

478 views

1 answer

sql - Performance and Readability of REGEXP_SUBSTR vs INSTR and SUBSTR

From My other question, Using REGEXP_SUBSTR with Strings Qualifier, I'm trying to decide which approach would be better ... #LIFE'); Thank you. See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

sql server - altering DEFAULT constraint on column SQL

I have an SQL script for creating a table, i would like the default of all but a few columns to ... the DEFAULT constraint of specific columns See Question&Answers more detail:os...

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

0 votes

402 views

1 answer

sql server - What are the different ways to replace a cursor?

I'd like to know your experience(s) with replacing SQL Server cursors in existing code, or how you took a ... How did you replace the cursor? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - PHP mysqli prepare statement not working

I am using a mysqli prepare statement to query my db with multiple constraints. I have ran the code in a test file of ... ["id"]=> int(1) } See Question&Answers more detail:os...

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

0 votes

799 views

1 answer

sql server - Getting the following sibling in an XPath when "following" axis is not supported

I am trying to get the text elements of a table that follows a paragraph that contains a specific text element ... axes? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

367 views

1 answer

sql - Insert multiple rows in one table based on number in another table

I am creating a database for the first time using Postgres 9.3 on MacOSX. Let's say I have table A and B. ... ) from b group by b.all_names; See Question&Answers more detail:os...

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

0 votes

430 views

1 answer

sql - MySQL LEFT JOIN duplicates results

I have a problem with implementing a module where one project can belong to multiple categories. Example: project " ... use GROUP BY or DISTINCT See Question&Answers more detail:os...

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

0 votes

345 views

1 answer

sql - insert into values with where clause

I am trying to programmatically enter values into my table. I cannot use a straight Select @variables. I have to ... WHERE MyID NOT IN (@MyID) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags