Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between distinct clause and group by
clause?
- 2 Answers
- 16697 Views
- HHH, Value Labs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is field with example?
What is normalization of database?
Explain table valued parameters in sql server? Why tvp used?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Explain log shipping?
What are the types of database recovery models?
Can we perform backup restore operation on tempdb? : sql server database administration
Explain the different types of backups available in sql server? : sql server database administration
What is an execution plan? How would you view the execution plan?
What are the new features of sql server 2012 reporting service?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Write an SQL query to obtain the 2nd highest salary.
What is 1nf 2nf?
Why I have to use stored procedures?
