Replace the string using REGEXP_REPLACE function in Teradata
REGEXP_REPLACE function in Teradata REGEXP_REPLACE is one of the regular expression function in Teradata. It is used to replace the
Continue readingHow to add partition to an existing table in Hive?
ALTER TABLE ADD PARTITION in Hive Alter table statement is used to change the table structure or properties of an
Continue readingHow to use COUNTIF function in Excel?
Excel COUNTIF function Description COUNTIF function is used to count the number of cells with in the range that meets
Continue readingPivot function in Teradata with examples
PIVOT in Teradata Pivot function is used for transforming rows into columns in Teradata. It allows us to aggregate and
Continue readingGrant Select access to table in Teradata
Grant in Teradata Grant statement is used to provide the privileges (permissions) such as SELECT,INSERT,UPDATE on a table to user.
Continue readingVLOOKUP Function in Excel
VLOOKUP in Excel Vlookup (“V” stands for Vertical) is a build in function in Excel. It is used to lookup(find)
Continue readingPercentage Formula in Excel with examples
Calculate a Percentage of a number in Excel Percentage is an expression of part of the whole. For example, You
Continue readingConcatenate cell values in Excel
In some cases, we want to concatenate/join the different column values to create the single value. There are two ways
Continue readingAlter table DROP column in Teradata
Drop a column in a table in Teradata We can use ALTER TABLE command to drop a column from an
Continue readingHow to Extract a Substring in Javascript?
Javascript is providing three different methods to extract the Substring from the given input string. The methods are listed below
Continue reading