How 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 readingHow to get the current date in Teradata with examples
Current Date in Teradata In Teradata, we can fetch the current date using either CURRENT_DATE or DATE in the Select
Continue readingHow to calculate the query execution time in Teradata
DBC Tables in Teradata – Data dictionary of Teradata Teradata stores the log of each and every SQL query data
Continue reading