SQL SELECT COUNT

In this SQL tutorial, you are going to learn how to use SQL SELECT COUNT Function along with syntax and examples. SQL COUNT Function is used to find the number of record returned in the result set. This function is … Read more »

SQL SELECT DISTINCT

SQL SELECT DISTINCT: The aim of this tutorial is to teach you how to use the SQL SELECT DISTINCT clause along with syntax and examples. The SQL SELECT DISTINCT clause is used to remove the duplicate records from the result … Read more »

SQL SELECT STATEMENT

The SQL SELECT statement is used to fetch records from one or more SQL tables or views in your database. The records fetched are known as resultset which is shown in tabular format. SQL or Structured Query Language is used … Read more »

SQL TEMP Tables

As the name suggests, Temporary Tables are temporary in nature but act as full features table until the connection is closed. The main difference between a permanent and a temporary table is that table definition and data stored is persistent … Read more »

SQL ALTER TABLE

The SQL ALTER TABLE statement is used to add, delete/drop, or modify columns in an existing SQL table. It is also used to add or drop constraints on an existing table. SQL ALTER TABLE – Add Column The ADD statement … Read more »

SQL COPY TABLE

The SQL COPY TABLE statement is used to copy data from one table to another table within the same database server. If you want to copy a SQL table to another table in the MySQL database, it is possible by … Read more »

How to Check Teradata Database Release and Version

DBC.DBCINFO table in Teradata will have all the related information related to the Teradata release and version. You can check Teradata Database Release and Version using the following query. select * from dbc.dbcinfo; Here, dbc – Database computer. dbcinfo – … Read more »

Changing the screen width in Teradata BTEQ

The default width in Teradata BTEQ setting display maximum of 75 characters in a single line. If we need to display more than 75 characters in a single line, we can set the width of the screen in Teradata BTEQ. … Read more »

Teradata Interview Questions

1. What is Master Index and Cylinder Index? Teradata uses logical address system, unlike other DBMS which are physical address system. This allows Teradata to locate the data easily if the data gets reallocated or de-fragmented. Master Index and Cylinder … Read more »

INSTR in Teradata

INSTR in Teradata is used to get the position of a search string in source string.  Syntax: select instr( source_string, search_string [,position[,occurrence]]) Example: SELECT INSTR(‘choose a chocolate chip cookie’,’ch’,2,2); The above query will return 20, indicating the position of string … Read more »