SQL Select Distinct: SQL SELECT DISTINCT query is used to return only unique values. It eliminates all the duplicated values. Syntax: SELECT DISTINCT column_name,column_name FROM table_name; 1 SELECT DISTINCT column_name,column_name FROM table_name; Example: SELECT DISTINCT Fours FROM SCOREBOARD; 1 SELECT DISTINCT Fours FROM SCOREBOARD; In the below image, you could find two SELECT queries. Total number of…
SQL WHERE Clause: The SQL WHERE clause is used to specify a condition while fetching the data from a table. We use WHERE clause to filter the records and fetching only necessary records. The WHERE clause is not only used in SELECT statement, but it is also used in UPDATE, DELETE statement, etc., SQL WHERE Clause…
SQL Select Query: SQL Select Query is used to select data from a Database. Syntax: SELECT column_name_1, column_name_2, .. column_name_n FROM table_name; 1 SELECT column_name_1, column_name_2, .. column_name_n FROM table_name; or SELECT * FROM table_name 1 SELECT * FROM table_name where * represents all the columns of the table. Example: To get all the records from a table.…
SQL Create Table: The SQL CREATE TABLE statement is used to create a new table in a database. Creating a table involves naming the table and defining its columns and data type of each column. SQL Create Table Syntax: CREATE TABLE table_name(column_name_1 data_type(size), column_name_2 data_type(size),.. , column_name_n data_type(size)); 1 CREATE TABLE table_name(column_name_1 data_type(size), column_name_2 data_type(size),.. , column_name_n data_type(size));…
SQL Create Database: The SQL CREATE DATABASE statement is used to create new SQL database Syntax: CREATE DATABASE databasename; 1 CREATE DATABASE databasename; Note: Always database name should be unique within the RDBMS. Also Read: SQL Create Table Example: I am creating a Database say TestDB Note: Make sure you have admin privilege before creating any database.…
SQL Operators: In this post, we see SQL Operators in detail. SQL Operator is a reserved word used primarily in an SQL statement’s WHERE clause to perform operations, such as arithmetic operations and comparisons. These are used to specify conditions in an SQL statement. There are are three types of Operators. Arithmetic Operators Comparison Operators Logical…
SQL Data Types: In this post, we see SQL Data Types in detail. In SQL Server, each column in a database table has a name and a data type. We need to decide what type of data to store inside each and every column of a table while creating a SQL table. How To Create an…
SQL Overview: SQL Overview: SQL stands for Structured Query Language. It is an American National Standard Institute (ANSI) standard. It is a standard language for accessing and manipulating databases. Using SQL, some of the action we could do are to create databases, tables, stored procedures (SP’s), execute queries, retrieve, insert, update, delete data against a database. SQL…
SQL Tutorial For Software Testers In this Free SQL Tutorial, we cover all SQL concepts in detail with easy to understand practical examples. This free tutorial is helpful for beginners to advanced level users. Who are the targeted audience of this Selenium Tutorial?Software Testers, QA Engineers SQL tutorial aims to teach beginners on how to…
Are you ready to ace your upcoming selenium job interview? Wouldn’t it be great if you knew exactly what questions a hiring manager would be asking you in your next selenium automation coding interview? We have also covered other topics related to you are as follows. Don’t miss to check out. TestNG Interview Questions Selenium…