Named SQL queries are those queries which are defined in mapping file and are called as required anywhere.
For example, we can write a SQL query in our XML mapping file as follows:
<sql-query name = "studentdetails">
<return alias="std"/>
SELECT std.STUDENT_ID AS {std.STUDENT_ID},
std.STUDENT_DISCIPLINE AS {std.discipline},
FROM Student std WHERE std.NAME LIKE :name
</sql-query>
Then this query can be called as follows:
List students = session.getNamedQuery(&quot;studentdetails&quot;)
.setString(&quot;TomBrady&quot;, name)
.setMaxResults(50)
.list();