Custom Search
 


Database SQL



Database development articles in Oracle, MySQL, SQLite, MS SQL Server, and SAS.


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:
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:



Copyright © 2017 GeeksEngine.com. All Rights Reserved.

This website is hosted by HostGator.

No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.

 
Home | Feedback | Terms of Use | Privacy Policy