SQL ORDER BY clause
May 30,92The SQL ORDER BY clause is used to sort the result-set by one or more columns. It is used when you want …
Read MoreSQL AND and OR operators
May 28,92In this lesson, you’ll learn how to use AND and OR operators to filter records based on more than one condition. Using …
Read MoreSQL WHERE clause
May 28,92Sometimes you want to fetch specific data from database table. This can be achieved by data filtration. Within a SELECT …
Read MoreSQL SELECT DISTINCT statement
May 27,92As you have seen, SELECT returns all matched rows. But what if you do not want same values to be …
Read MoreSQL SELECT statement
May 27,92The SQL SELECT statement is used to retrieve information from one or more tables. To use SELECT to retrieve table data …
Read MoreSQL syntax
May 26,92Data in relational databases is stored in tables that are largely independent of each other. You can easily add, delete, or …
Read More