The SQL SELECT DISTINCT Statement

By -
The SQL SELECT DISTINCT Statement
The SELECT DISTINCT statement is used to return only distinct (different) values.
Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.
The SELECT DISTINCT statement is used to return only distinct (different) values.
SELECT DISTINCT Syntax
SELECT DISTINCT column1, column2, ...
FROM table_name;


Comments

Post a Comment

Popular posts from this blog

Importance of testng.xml file

By -
In a Selenium TestNG project, we use  testng.xml  file to configure the complete test suite in a single file. Some of the features are as follows. testng.xml file allows to include or exclude the execution of test methods and test groups It allows to pass parameters to the test cases Allows to add group dependencies Allows to add priorities to the test cases Allows to configure parallel execution of test cases Allows to parameterize the test cases 7. How to pass parameter through  testng.xml  file to a test case? We could define the parameters in the  testng.xml  file and then reference those parameters in the source files. Create a java test class, say,  ParameterizedTest. java  and add a test method say  parameterizedTest()  to the test class. This method takes a string as input parameter. Add the annotation @Parameters(“browser”) to this method. 1 2 3 4 5 6 7 8 9 10 11 12 // ...
Read more

Handling Dynamic Web Tables Using Selenium WebDriver

By -
Image
There are two types of HTML tables published on the web- Static tables : Data is static i.e. Number of rows and columns are fixed. Dynamic tables : Data is dynamic i.e. Number of rows and columns are NOT fixed.Handling static table is easy, but dynamic table is a little bit difficult as rows and columns are not constant. Using X-Path to Locate Web Table Elements Before we locate web element, first let's understands- What is a web element? Web elements are nothing but HTML elements like textbox, dropdowns radio buttons, submit buttons, etc. These HTML elements are written with  start  tag and ends with an  end  tag. For Example, <p>  My First HTML Document </p>. Steps for getting X-path of web element that we want to locate. Step 1)  In Chrome, Go to  http://money.rediff.com/gainers/bsc/daily/groupa Step 2)  Right click on web element whose x-path is to be fetched. In our case, right click on "Company" Se...
Read more

Explain bug leakage and bug release.

By -
Bug Leakage:   When customer or end user discovered a bug which can be detected by the testing team. Or when a bug is detected which can be detected in pervious build then this is called as Bug Leakage. Bug release:  is when a build is handed to testing team with knowing that defect is present in the release. The priority and severity of bug is low. It is done when customer want the application on the time. Customer can tolerate the bug in the released then the delay in getting the application and the cost involved in removing that bug. These bugs are mentioned in the Release Notes handed to client for the future improvement chances.
Read more