As mentioned earlier while you want to limit the rows with the usage of ‘WHERE’ clause at the same time you can also use the IN operator to have multiple values in the ‘WHERE’ clause. This is an alternative use of having multiple OR. Here is the syntax. SELECT {*|<Col1>}, <Col2>, <Col3>… FROM <table name> [...]

Like many other Structured Query Languages, to a very large extent, Teradata SQL is also ANSI compatible and also there are extensions available for the same. Let’s start with some basic operators we use in our day to day query building. As you know the SELECT statement returns all the rows of a table and [...]