Select number of records from a table using TOP function in Teradata
Some time we wants to fetch sample rows from the table. If we use SELECT * in the query,it will
Continue readingCalculate BMI(Body Mass Index) using PHP program
BMI calculator: Body mass index (BMI) is a measure of body fat based on height and weight that applies to
Continue readingTeradata XMLAGG function with examples
XMLAGG function: The XMLAGG function is used to perform an aggregate of multiple rows. This can used for multiple purpose
Continue readingCreate the table from another table using create table as select in Teradata
Teradata provides the option to copy the existing table structure and create the new table.We can either copy the table
Continue readingConvert javascript object to JSON using JSON stringify method with examples
JSON.stringify() function: The Javascript function JSON.stringify() is used to convert the javascript object to JSON string. Syntax for JSON.stringify(): Explanation:
Continue readingFind date difference between consecutive rows in Teradata
Calculate date difference between consecutive rows Sometime we will get the requirement to calculate the date difference for consecutive rows
Continue readingTeradata create table syntax with examples
We can create SET/MULTISET tables in Teradata. There are few differences between SET and MULTISET tables.Let’s discuss about syntax to
Continue readingTeradata Position function -To get the position of substring in a string
Position function in Teradata: Teradata provides lot of functions to manipulate the string.Position function is used to get the position
Continue readingPlot a graph in python using matplotlib
There are many libraries available in python to plot the graph.matplotlib is one of the widely used library to draw
Continue readingGetting user input from keyboard in Python
We can get the user input using input() function in python.There is one more function raw_input() that used to get
Continue reading