Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16813 Views
- HHH, Value Labs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swamy
Distinct Clause:
---------------
Distinct Clause Will Eliminate the Duplicate data or Rows
when u r selecting from table .So it Produce the Data or
Rows with out Duplication.Generally Distinct Clause will
be Placed on the Column of the Table.
Group Clause:
-------------
Group Clause will group or pack the rows or data based on
the Column(S).
| Is This Answer Correct ? | 24 Yes | 5 No |
Answer / rkvenky
distinct suppress the duplicates of data in the select stmt.
where as group by combines the data which we willgive in
order.
2.group by used at the end of select stmt
distint used in select stmt to columns
3.
group by is function where distinct is keyword
| Is This Answer Correct ? | 8 Yes | 13 No |
What is a scheduled job or what is a scheduled task?
What is history table in sql server?
What function does a database engine serve in the sql server?
What are the differences between left join and inner join in sql server?
What are the different Topologies in which Replication can be configured?
How to include text values in sql statements?
How to apply cascading referential integrity in place of triggers?
How retrieve field names from the table in SQL through JAVA code?
Can you please explain the difference between primary keys and foreign keys?
How do I create a stored procedure in dbml?
How will you go about resolving deadlocks?
Do you know the capabilities of cursors?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
