Definition, Comparison and Difference between HAVING and WHERE Clause N B 5/05/2014 09:22:00 pm 0 Definition, Comparison and Difference between HAVING and WHERE Clause Where clause doesn’t work with aggregates – like sum, avg, max, et... Read more »
Index in Database N B 5/05/2014 09:01:00 pm 0 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 N B 5/05/2014 08:58:00 pm 0 Difference between TRUNCATE, DELETE and DROP commands Delete is a DML(Data Manipulation Language). Delete command deletes records fro... Read more »