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 Database. Show all posts
Showing posts with label Database. 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 »
Friday, 27 September 2013
Database Testing Checklist
1.) Data integrity The complete data belonging to each entity should be stored in the database. Depending on the database design, t...
Read more »
