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.
GROUP BY is used to group values from a column, and, if necessary, perform calculations on that column. You can use aggregation functions (e.g. COUNT, SUM, AVG) on the grouped column.
The result of the GROUP BY is ordered by the column that grouped.
The ORDER BY clause is used only for ordering the query results.
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
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
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
gand maro...is the answer
sql exception which provides information on database access errors where as sql warning provides inforamation on database access warnings.
The difference between Pervasive SQL and MS SQL are slight and of a rather technical nature. To the typical consumer the functionality is very much the same, though performance may vary depending upon the use.
god only knows
datediff
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.
RECORD type works only in PL/SQL. But OBJECT type gets stored in database and can be used in both SQL and PL/SQL (without redefining it in PL/SQL).
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com