0
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is the difference between hql and criteria?
HQL is to perform both select and non-select operations on data, but Criteria is only for selecting data, we can't perform non-select operations using criteria.HQL is suitable for executing static queries, where as Criteria is suitable for dynamic queries.HQL doesn't support pagination concept, but we can achieve pagination with Criteria.Criteria used to take more time to execute than HQL.With Criteria we are safe with SQL injection, because of its dynamic query operation, but in HQL as your queries are either fixed or parametrized , there is no safe for SQL injection.
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.
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.
What are the differences between Pervasive SQL and MS SQL?
Pervasive SQL is a relational database management system designed for embedded applications, while MS SQL, or Microsoft SQL Server, is a full-fledged RDBMS with advanced features for enterprise applications. MS SQL provides more robust scalability, security, and integration options compared to Pervasive SQL. Additionally, MS SQL is commonly used in larger organizations, while Pervasive SQL is often utilized in smaller businesses and embedded systems.
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
Difference between Object-based Data Model and Record-based Data Model?
Object-based data model represents data as objects with attributes and methods, providing a way to model real-world entities in a programming language like Java. On the other hand, record-based data model organizes data into fixed-format records or tuples, typically used in databases like SQL to store and retrieve structured information. Object-based data model offers a more dynamic and flexible way to represent data compared to the rigid structure of record-based models.
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
What is the difference between SQL and the other programming languages?
SQL is a query based language that is used to manipulate data stored in a database while other languages process data.
