How to Remove Duplicate Rows from a Table

Use rowid pseudo column. All you have to do is to keep the latest data (i.e. highest ROWID) and remove other duplicated rows. SELECT * FROM table1 a WHERE rowid < (SELECT max(rowid) FROM table1

How to generate ER diagram using Oracle SQL developer

Tool Used : SQL Developer version 3.1.07 Schema Used : HR Tables Used : Countries, Departments, Employees, Job_History, Jobs, Locations, Regions Navigate the below path and step by step screen shots: File > Data Modeler

How to create MySQL Database, Tables in Linux

I have used Red Hat Linux for creating MySQL database so kindly make changes in the commands as per your distribution.   Installing MySQL Make sure mysql package is installed in your machine which you