Between Operator in SQL
Between Operator in SQL is used to filter out the output within a specified range specified in the WHERE condition. It can be used with SELECT, INSERT,UPDATE or DELETE SQL statements. Syntax : SELECT...
Category: ETL Testing
Pattern Matching in SQL – Using Wildcards
In the previous post we have studied about the ‘WHERE’ clause (used to filter out the output ) and the ‘EQUALITY’ operator ( used along with the WHERE clause to specify the filter condition)....
Where Clause
Where Clause….is used to filter results from SQL statements like Insert,Update,Select,Delete that meet the filter criteria. Syntax : SELECT * FROM <Tablename> WHERE <Column> = <Value>; Sample Database ILLUSTRATION OF WHERE CLAUSE USING...
Tidal Enterprise Scheduler Tutorial
In this post, we will learn what is Tidal and its use to schedule the jobs in informatica. What is Tidal Enterprise Scheduler (TES)? Tidal is a scheduling tool with the help of which...
Character Functions()
Sample Database : There are following Character Functions(). 1. INITCAP() It converts the Initial letter of every word into Upper Case and rest in Lower case. This changes are only temporary and done only in...
SQL Interview Questions part 12
You can see part 11 here. 166)Display the department name along with total salary in each department. 167) Display itemname and total sales amount for each item. 168) Write a Query To Delete The...
SQL Interview Questions part 11
You can see part 10 here. 151) My boss has changed his mind. Now he doesn’t want to pay more than 10,000.so revoke that salary constraint. 152) Add column called as mgr to your emp...
SQL Interview Questions part 10
You can see part 9 here. 136) Display the 10th record of emp table without using group by and rowid? 137) Delete the 10th record of emp table; 138) Create a copy of emp table;...
System Defined Functions in SQL
Functions can basically be divided into two types : User Defined System Defined. System Defined Functions in SQL: In this Post we will discuss about the System Defined or Inbuilt functions provided by SQL...