Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: minus

Oracle Alternative to EXISTS EXCEPT

By adminPosted on August 13, 2023

Question : I wonder if there is an equally elegant solution for Oracle for the problem posted and answered here: […]

Oracle: finding rows without children in a table with a foreign key?

By adminPosted on June 30, 2023

Question : Suppose I have two tables with a foreign key relationship. How can I find the rows in the […]

How to select students that failed at least at all courses that student with id = 1 failed?

By adminPosted on February 3, 2023

Question : I have the following tables: STUDENT (student_id, first_name, last_name, birth_date, year , domain) PROFESSOR (professor_id, first_name, last_name, birth_date, […]

ORA-00907: missing right parenthesis on query with subqueries and EXCEPT operator

By adminPosted on January 4, 2022

Question : I am getting ORA-00907: missing right parenthesis for the following query: SELECT PEOPLE.NAME FROM CLIENTS K INNER JOIN […]

How to select students that failed at least at all courses that student with id = 1 failed?

By adminPosted on March 21, 2021

Question : I have the following tables: STUDENT (student_id, first_name, last_name, birth_date, year , domain) PROFESSOR (professor_id, first_name, last_name, birth_date, […]

Select items that have never been ordered using the MINUS operator

By adminPosted on February 16, 2021

Question : I have the following two tables: ITEM (Item#, Item_Name, Unit_Price) ORDER_ITEM (Order#, Item#, Qty) Now, how do I […]

Recent Posts

  • connect SQL server file (mdf) with R tool [closed]
  • Database running out of space
  • Postgres backup PITR strategies [closed]
  • Installing SQL Server 2014 Enterprise in Windows 7 Ultimate 64 Bit Incompatibility Error
  • CPU Time Slower in SQL Server 2014 than in SQL Server 2008 R2 [closed]
  • Postgres doesn’t use expression index for group by
  • Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)
  • Creating Indexes to optimize query
  • Does joining to the same table twice have a predictable performance impact
  • Can we prevent table from update directly but allow update using trigger from another table?
  • Querying ‘random’ Oracle data via openquery in SQL Server returning the same data for multiple runs
  • The implications of lack on indexes on supporting a large production database
  • How to limit work_mem on PostgreSQL
  • Select max(pk) instead of sequence.nextval
  • Query detailing differences between rows for a large amount of data
  • How to combine `delete` and `insert` operations in one statement?
  • Slow SQL Server database on a specific server [duplicate]
  • How to model the relationship between these three tables
  • Error when migrating MySQL 8 to SQL Server 2019
  • multiple MYSQL full text indexing for innodb and memory + disk efficiency

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding