How To Find The Second Largest Number in SQL?
DBARepublic.com • 1:52 PM
Out of the box, most database management systems available today come with built in functions like MAX or MIN. These functions are very com...Read More
Results for >>:::
SQL
50 Database Terminologies That Every Developer Should Know
DBARepublic.com • 2:48 PM
This blog lists 50 most important concepts that developer and other IT professional should know about database. Every application you use to...Read More
Data Definition Language & little more...
DBARepublic.com • 8:44 AM
Data Definition Language (DDL) : Data Definition Language statement defines structurally change and drop of schema objects. For example, DDL...Read More
Data Manipulation Language
DBARepublic.com • 1:24 PM
Data Manipulation language (DML) statements access and manipulate data in existing table, view or in a materialized view. The effect of a ...Read More
Create Table As Select - CTAS
DBARepublic.com • 1:37 PM
Create Table As Select aka CTAS. CTAS quickly lets your create a new table modeled after a table that already exist in your database. I use ...Read More
Insert into Select ...
DBARepublic.com • 10:05 PM
Insert into Select Insert Into Select: This SQL statement is pretty straight forward that needs no explanation. However, I will explain...Read More
How to Delete Duplicate Record?
DBARepublic.com • 10:08 PM
This article does not talk about the “duplicate” that you are used to hearing. We aren't talking about the knock-off products AKA "...Read More
What is a SYNONYM?
DBARepublic.com • 10:56 AM
Synonym Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class s...Read More
Database Constraints
DBARepublic.com • 4:29 PM
A wise man once said: " Data must protect itself! ". This is exactly what database constraints do. A rule that restricts the...Read More
Slow Insert
DBARepublic.com • 1:12 PM
Do you deal with large data set in your organization? If yes, this is a must read for you. I have worked on a project where the small table ...Read More
Subscribe to:
Posts
(
Atom
)
