The AngularJS ng-option directive use to fill data in dropdown lists based on an array or an object. You can alson use ng- repeat directive to fill data in dropdown lists based on an array or an object.

The AngularJS ng-option or ng-repeat directive help us to bind data in dropdown lists based on an array or an object. If you want to bind a dropdown list, based on an object or an array in AngularJS, you should use the ng-option or ng-repeat directive.

The ORDER BY Keyword is used to sort the data in ascending or descending order, based on one or more columns. The ORDER BY keyword by default sort the data in ascending.

The SQL WHERE clause is used to define a criteria while retrieving the data from the table. When you need to retrieve only necessary records based on filter should use to where clause.

SQL select statement is used to retrieves the data from a database table which returns data in a table-like structure called a result-set.

The UNION ALL command is used to combine the result set from two or more tables, when using the UNION ALL command all selected columns need to be of the same data type.

The UNION command is used to combine the information from two or more tables, when using the UNION command all selected columns need to be of the same data type. With UNION command only distinct values are selected.

Having clause enables you to filter data based on the group functions. This is similar to WHERE condition. But it must use with group functions. Group functions cannot be used in WHERE Clause. But Group functions can be used in HAVING clause.

In Sql Server, we have group by clause for grouping the records of the database table according to our need in other words the SQL GROUP BY Clause is used to retrieve data grouped according to our need based on one or more columns. GROUP BY returns one record for each group.

A Multi-Statement Table-Valued user-defined function return result as a table. It can have a single or multiple T-SQL statement. When you create a Multi - Statement Table-Valued function, You must define the table structure that is being returned result. You can also use the SQL Data Manipulation Language (DML) Statements INSERT, UPDATE, DELETE to create and manipulate the return results in the table variable that will be returned as the result.