answersLogoWhite

0

where- In this all the data is stored in the buffer after that required one is selected as an output.

Groupp By- In buffer's all the row's are selected after that grouping is taken place , the superior values is selected for each rows.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What is the difference between T-sql and sql?

T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.


What is the difference between hql and sql?

one of the difference is HQL does not support distinct but SQL supports the distinct in the query


Difference between sql and sql plus?

SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database


Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


What is the difference between quel SQL and qbe?

gand maro...is the answer


Difference between SQL Exception class and SQL Warning class?

sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.


Difference between oracle 10g and sql in points?

god only knows


Which date function is used to find the difference between two dates in SQL?

datediff


What is the difference between catalog schema and database in SQL Server?

A catalog is simple a group of related schema collected together in a defined namespace. While schema is a group of one or more related object collected in a common namespace.


What are difference between cache database and sql database?

CACHE is multidimensional and postconsonantal database and its supporting scripting


Difference between sql function and sql procedure?

Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com


Difference between roll back and commit in sql?

in sql commit is used for saving the changes made in database and roll back is to roll back them , changes will not get saved in the database