I have two tables First table INTRA.TABLE_A Second table EXTRA.TABLE_B And I am trying to get data from INTRA.TABLE_A into EXTRA.TABLE_B with update: But it “throws” syntax error at FROM word: syntax_error After update, result should looks like: I am using sqlDeveloper and Oracle database. How can…
Tag: subquery
I need to optimize this MYSQL query
I have tried NOT EXIST but didn’t get expected result can’t do index since duplicate entries of student_id,status are valid entries,Need to reduce execution time since the table has large number of data. Answer You can try query with JOIN condition: Here the fiddle SQLize.online Sure that your tab…
Simplify nested queries
select name from person, author, article where name != “John Doe” AND person.pid = author.pid AND author.aid = article.aid AND title = select title from …
How to incrementally count the number of repeated instances
I want to incrementally count the number of repeated instances in a table, so if I have a table like this: Using the column “name” as reference, the output would be The DBMS implementation is MySQL, version 5.6 Answer In MySQL 5.x, where window functions are not available, one option uses a correl…
MySQL Select all from Table 1 where Foreign key not exists or is not equal to specified key
Hello I can’t figure out how to write this select statement. I have the following schema: table 1 1:n table 2 n:1 table 3 So I got a n:m between table 1 and 3 what I want to do now is get all entries in table 1 that either don’t have an relation to table 3 via table 2 or
Shifting the total group by 1 step- MYSQL [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 2 years ago. Improve this question Here I have name and pay as columns of a database table. Table has Name an…
Problem with Concat results searching in MYSQL
Hi this is the query I’m trying to achieve results with but how can I get the search for concat results in that column? Answer You can’t refer to an alias defined in the select clause in the same scope (left apart the order by clause). In very recent versions of MySQL (8.0.14 or higher), you can u…
Query not returning expected data
I’m looking for an explanation for why 1 of the following 3 queries aren’t returning what I am expecting. Assume the following: Anmodning with ANNo=1, ANCpr=1111112222 And the Person table doesn’t have a row with PSCpr=111111-2222 Queries are executed in Management Studio against a SQL Serve…
Update field with values from a select query/subquery in SQL
Hello I need to select a specific string form a field one table and then populate another field in a different table in the same SQL database. I am extracting the date from a field. The characters are between two underscores. I was able to create the Select statement correctly using guidance from a previous p…
Single-row subquery returns more than one row BUT with one row
“CityJail” schema. I am supposed to find each appeal that has a less than the average number of days between the filing and hearing dates. Here is my code: I get an error: ORA-01427: single-row subquery returns more than one row 01427. 00000 – “single-row subquery returns more than one…