Database SQL





1. Get single records when duplicate records exist

Here is a SQL tip about how to get single records when duplicate records exist in a table.

2. Find duplicate values or non-duplicate values in a table

Tips for retrieving duplicated and non-duplicated values in Oracle.

3. How to get Top 1 record from Oracle by using PL/SQL

This article explains how to use Oracle function to select the top 1 record from Oracle by using PL/SQL.

4. How to get Top N rows from Oracle by using SQL

To get top N records from Oracle is tricky and there are basically three ways to get them by using Oracle SQL.

5. Convert MS Access Northwind database to Oracle

In this article, we are going to convert the popular Microsoft Access Northwind database to Oracle. Many of the database objects like constraints, index, auto number, etc., are migrated to relevant Oracle objects.

   Inside this article:

• How the data types in Access Northwind are converted to Oracle
• Building Oracle Northwind database objects
• Queries to generate aggregated data for Oracle Northwind database

6. How to do cross table update in Oracle

This article shows you 4 ways to do cross table update in Oracle.

7. How to export Northwind Access database to MySQL

In this article, we are going to export the popular Microsoft Access Northwind database to MySQL database by using MySQL ODBC Driver. After the migration, you will be able to use MySQL Northwind to explore the rich functionalities of working with MySQL.

   Inside this article:

• Export Northwind Access database to MySQL via ODBC
• Make northwind a true relational database in MySQL
• Restore northwind database from SQL dump
• Northwind database schema
• Implement file directory based image management

(Listing 1 - 7 of 7)  First | Prev | Next | Last