Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16566 Views
- HHH, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create a view using data from another view?
What is transaction server auto commit?
Explain magic tables in sql server?
What is the difference between a function and a stored procedure?
What authentication modes does sql server support?
Difference between LEN() and DATALENGTH() in sql server ?
What are the advantages of having an index on the sql server?
What are the transaction properties?
Explain sub-query?
What is the server name for sql management studio?
How to change a login name in ms sql server?
What is merge replication?
What the class forname () does?
Is it true, that there is no difference between a rule and a check constraint?
How to run sql server 2005 books online on your local system?
