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
How To Find The Second Largest Number in SQL?
Reviewed by DBARepublic.com
on
1:52 PM
Rating: 5
This blog lists 50 most important concepts that developer and other IT professional should know about database. Every application you use to...Read More
50 Database Terminologies That Every Developer Should Know
Reviewed by DBARepublic.com
on
2:48 PM
Rating: 5
Data Definition Language (DDL) : Data Definition Language statement defines structurally change and drop of schema objects. For example, DDL...Read More
Data Definition Language & little more...
Reviewed by DBARepublic.com
on
8:44 AM
Rating: 5
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
Create Table As Select - CTAS
Reviewed by DBARepublic.com
on
1:37 PM
Rating: 5
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
Slow Insert
Reviewed by DBARepublic.com
on
1:12 PM
Rating: 5