What do you mean by SELECT DISTINCT Statement in Sql? ,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher
What do you mean by SELECT DISTINCT Statement in Sql?

Distinct Statement is basically use when in the table  some of the columns may contain duplicate values. 

It is not a problem .some time we want to be these type of values like :

If we have a any table , and we wold like to know the name of those persons who are from same place. that time we use this statement :

Syntax :  SELECT DISTINCT column_name(s) FROM table_name
Example:SELECT DISTINCT City FROM employer;

More interview questions and answers
What you define SAX in XML?
How you define DOM in XML?
What is RAID and what are different types of RAID configurations?
Discuss about Disadvantages of cursors?
What does COMMIT do?
What is Oracle locking?
What Oracle lock modes do you know?
What is query optimization?
What are the main components of Database management systems software.
What are the main attributes of database management system?
What databases do you know?
In what sequence SQL statement are processed?
How SAX is different than DOM?
How you define XMLA?
What is XHTML?
How You create the Table ?
what do you know about XML parser?
How can I Insert some data into the created table.
How can I Update the table?
How can I see the whole Table ?
How can i short list to the table with resect to the column?
How can I retrieve few columns of all rows?
How can I retrieve all columns of a particular row ?
How can I retrieve selected columns of a particular row?
How can I retrieve a row with columns having a particular pattern?
How can I count number of records in the table?
How can I get the sum of a column?
How can I Use AND/OR in WHERE clause to retrieve data based on multiple condition?
How can I got group the results?
How can I Having Clouse?
How Can I use IN Clause?
How XML support UNICODE characters ?
How to create an XML Document? Explain it with example.
How XML support TREE Structure?
How can I Add a column to the table?
How can I set an alias for person table using few columns only?
How can I delete a particular record in the Table ?
How can I delete all records of the table ?
How can I delete all records for using TRUNCATE command?
How can I drop the column added in step 10 above?
How can I drop the created table?
How can I drop the database?
How can I know max value of numeric column in the table ?
Write some basic rules of XML?
How can I know Min value of numeric column in the table ?
Describe TO_DATE function?
How can I know Avg value of numeric column in the table ?
What do you mean by SELECT DISTINCT Statement in Sql?
How to define XML Element?
How can i use the TOP Clause in the SQL?
How you define attributes in XML?
What is the Sql Wild card?
How can i use the % Wildcard ?
How can I use _ Wildcard?
How can i use [charlist] Wildcard?
How you define XML Entity?
How to write comment in XML?
How you define DTD in XML?
What is the XML prolog?
Choose true 1.Hibernate is a framework. 2.Hibernate is an object-relational mapping (ORM) library for the Java language 3.Hibernate provides a mapping for object-oriented domain model to a traditional relational database. 4.All of the above 5.None
What you understand with document validity?
How you define Tree Structure in XML?
What are the disadvantage of XML?
What the use of SQL Alias In sql query?
How can use The INNER JOIN Keyword in Sql?
What are the advantage of XML?
How can I use LEFT JOIN Keyword?
What is the use of RIGHT JOIN Keyword?
How can i use FULL JOIN Keyword?
What is XSLT?
How we use CSS with XML?
How can I use the UNION Operator?
How to display XML data as HTML?
How can i use INTO Statement ?
HOw can i create the Database?
How do we use NOT NULL Constraint?
What is the XMLHttpRequest Object?
How to create an XMLHttpRequest Object?
How can I create the Index?
What is the use of FIRST() Function?
What is the use of LAST() Function?
What is the use of UCASE() Function?
What is the use of LCASE() Function?
What is the use of MID() Function?
what is the use of LEN() Function?
HOW can i use the ROUND() Function?
How can i use to the NOW() Function?
How can i use to the FORMAT() Function?
What do you understand about XML Serialization and Binary Serialization?
How to define tag name in XML?
What is the CDATA section in HTML?
Why we called XML as self-describing data?
How we define an empty XML element?
How we use xml.onload?
How we write the comments in the XML file?
Where data is stored in XML?
How we can say that XML is extensible?
What is the difference between URL instance and URLConnection instance?
What do you understand about Schema?
How do I make a connection to URL?