Labels
- AVG() Function (1)
- Aggregate Functions (1)
- Candidate Key (1)
- Composite and Compound Keys (1)
- EXISTS (1)
- FIRST() Function (1)
- Group By Statement (1)
- Having Clause (1)
- INSERT (1)
- LIKE (1)
- SELECT AS CLAUSE (1)
- SQL Distinct Unique Records (1)
- SQL IN (1)
- SQL Joins (1)
- SQL Last() Function (1)
- SQL NULL Conditional (1)
- SQL Not Exists (1)
- SQLComparison Operators (1)
- Sql Max() Function (1)
- Sql Min() Function (1)
- Sql SUM() Function (1)
- WHERE (1)
Blog Archive
-
▼
2010
(73)
-
▼
May
(40)
- Generate Mapping against target Step
- Pentaho Spoon Installation
- Group by SQL Query
- How to Insert Extracted Values in Pentaho Spoon
- Loading XML Data Using Pentaho ETL Tool
- SQL Query For Monthly Calculation
- Concatenation in Pentaho Kettle
- How to Split a String in pentaho Kettle
- Date to String Conversion in Pentaho Kettle
- How to get Distinct Count in Pentaho
- How to Write ETL Script in Pentaho
- Check Table Column Existence in Pentaho
- Performing Calculations in Pentaho Spoon
- Aggregate Functions in Pentaho Spoon
- What is Checksum in Pentaho Spoon
- Hex to integer Conversion in Kettle
- How to Set Environment Variables in Kettle
- What is Get Variable in Pentaho Kettle
- What is Set Variable in Pentaho Kettle
- Storing Transformations and Jobs in local Files Sy...
- What is Pentaho
- ETL Scripting with Open Source ETL Tools
- SELECT AS CLAUSE
- Calculations in SQL Query
- SQL Distinct Unique Records
- SQL IN, NOT IN and NOT BETWEEN Clauses
- SQL Between Clause
- SQL Multiple Conditional Queries
- SQL NULL Conditional Queries
- SQL Comparison Operators
- Candidate Key
- Super Key
- Composite & Compound keys
- Foreign key
- Alternate or Secondary Key
- Surrogate Key
- Unique key
- Primary Key
- Database Keys
- What Nomalization is?
-
▼
May
(40)
Saturday, May 8, 2010
SQL Distinct Unique Records
at
10:31 PM
Posted by
M.Junaid Khan
0
comments
The Below Query will select all rows this will also include repetative or redundent rows i..e un necessary or duplicated rows i.e. UNIQUE Records
SELECT WORKDEPT
FROM EMP
Distinct rows:
This is will extract all the rows but will remove the duplicated rows
1.SELECT DISTINCT WORKDEPT
FROM EMP
2.SELECT DISTINCT WORKDEPT, JOB
FROM EMP
Distinct Count
One person can send many feedack / comments against this post so count the unique no of person who posted their comments
SELECT POSTED_BY,COUNT(DISTINCT COMMENTS)
FROM FEEDBACK
GROUP BY POSTED_BY
Posted under :
SQL Distinct Unique Records
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment