SQL – Logical Functions SQL logical functions are used primarily for checking (or testing) the truth of some conditions. A logical function performs a logical operation or comparison on objects and expressions and returns a boolean value − Sr.No. Function & Description 1 Returns a item from the list at the specified index value. 2 […]
Category Archives: sql
SQL – Statistical Functions SQL server Statistical functions work on SQL server tables and views and exploit all database parallelism, scalability, user privileges and security schemes. Hence the SQL statistical functions can be included and exposed within SQL queries − Sr.No. Function & Description 1 Returns number of attempted connections. 2 Returns amount of time, […]
SQL – Handling Duplicates Table of content Sometimes, tables or result sets contain duplicate records. While in most cases, duplicates are allowed, there are situations where it is necessary to prevent duplicate records and remove them from a database table. Why is Handling Duplicates in SQL Necessary? Handling duplicates in an SQL database becomes necessary […]