Definition, Comparison and Difference between HAVING and WHERE Clause
Definition, Comparison and Difference between HAVING and WHERE Clause Where clause doesn’t work with aggregates – like sum, avg, max, et...
Read more »
Showing posts with label Sql. Show all posts
Showing posts with label Sql. Show all posts
Monday, 5 May 2014
Index in Database
What is an index? An index is a data structure that stores the values for a specific column in a table. An index is created on a column...
Read more »
Difference between TRUNCATE, DELETE and DROP commands
Difference between TRUNCATE, DELETE and DROP commands Delete is a DML(Data Manipulation Language). Delete command deletes records fro...
Read more »
