select distinct sql

Components of 3 tier architecture – Web server vs Application server vs Database server

Web server serves a web content (HTML and static content) over the HTTP protocol. Application server is a container on which one can build and expose business logic and processes to client applications through various protocols like HTTP. Some cases it will have internal web server. Application server is heavy in terms of resource usage. …

Components of 3 tier architecture – Web server vs Application server vs Database server Read More »

What is difference between select and select distinct

What is the difference between select  and select distinct SELECT DISTINCT statement is used for returning only distinct (different) values from a column. SELECT statement is used for returning all the values in the table column. E.g SELECT States FROM Customers;E.g SELECT DISTINCT States FROM Customers; Summary of SQL – Please click here