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.
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.
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.
CACHE is multidimensional and postconsonantal database and its supporting scripting
Function is must be return the value but procedure cannot be returned, for more information please visit the link : http://youropensource.com
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