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();