In this section, we cover common string functions seen in SQL. Different RDBMS may employ different string functions, and there may also be differences in the syntax for each RDBMS even when the function call is the same. All such differences are explained in each section. Please note that we Continue Reading
When you need to combine information from multiple tables or queries, SQL set operators are a useful tool. SQL queries let us choose the most important bits from large amounts of information. Of course, we can’t expect that all necessary data will be stored in one table. Let’s say we Continue Reading
BETWEEN AND COALESCE() NULL Safe equal to operator (<=>) Equal operator(=) Greater than or equal operator(>=) Greater than operator(>) GREATEST() IN() INTERVAL() IS NOT NULL IS NOT IS NULL IS ISNULL() LEAST() LESS THAN OR EQUAL OPERATOR(<=) LESS THAN OPERATOR(<) LIKE NOT BETWEEN AND NOT EQUAL OPERATOR(<>,!=) NOT IN() NOT Continue Reading
SELECT data from table which recorded to a specific Date?
https://www.techonthenet.com/sql_server/functions/index.php The Above URL will help you in making your SQL Query as simple as it could be: For e.g. You want to fetch the Data for Current Year (or any previous year) Select * from [table_name] where year [column_date] = 2019