While working with SQL, one of the question which often creates confusion is whether to use where or having clause.Though it appears that both clauses do the same thing, they do it in different ways.Here in this article, I will try to highlight all the major differences between WHERE and HAVING, and things you should be aware of, when using either WHERE or HAVING. » Read more
Hewlett Packard is looking for experienced Business Intelligence developers for Chennai/Bangalore location » Read more
So you planning to build Data Warehouse? But not able to decide which is the right ETL tool for you business.I can understand your confusion because choosing the right ETL tool is the most daunting task when you are planning to build a data warehouse. Once you chose the right ETL tool, more than 70% of work is done. » Read more
Happiest Minds is looking for experienced Pentaho ETL developers for bangalore location. » Read more
1. What is SQL ?
SQL stands for Structured Query Language.It is a database language used for database creation, deletion, fetching rows and modifying rows etc. » Read more
Select statement is a DML (Data Manipulation Language) statement.The SELECT statement is an SQL statement that specifies which rows and columns to fetch from one or more tables or views. The SELECT statement is very helpful in finding filtered records from a database. » Read more