how I do select from select in hql

select RN from (

select rownum RN, dbid from ( select * from profile p where type = 1912 and name like 'a%' order by globalid ) )

where db_id = 259;

this is the sql

The below hql doesn't work

select RN from ( select rownum RN, DBId from ( select distinct p from com.eci.sid.profile.Profile p where p.profileKey.profileType = ? order by p.profileKey.name
) )
where DBId = ?

View Answers

October 27, 2011 at 11:36 AM

Please visit the following link:

HQL Select Example

Ads

Advertisements

how to select the row value that was retrived from the database ?
how to select the row value that was retrived from the database ? I... in the page in which i am getting all the data from the database has an another select option as : Approve, Disapprove & Pending. Now if i select any option

Select from select list + display
Select from select list + display i have a select list containing... select EmpCode from the select list, the corresponding EmpName and DeptName should...=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp

how to select random rows from database through servlet
how to select random rows from database through servlet hello i want to know, how to select random rows from database through servlet

mysql select from multiple tables
mysql select from multiple tables how can i select the date field from multiple tables in mysql? "UNION" can be used to select data from multiple tables in my sql... for example (SELECT * from name where `name

How do I set environment variables from Java?
How do I set environment variables from Java? How do I set environment variables from Java

Hibernate SELECT Clause
Hibernate SELECT Clause In this tutorial you will learn how to use HQL select... for selecting the data from the database. Example : Here I am giving a simple example which will demonstrate you how a HQL select clause can be used. To achieve

How to use select Statement in MySQL?
How to use select Statement in MySQL? Hi, How to use select Statement in MySQL? I want to learn the various ways to use the SQL select statement... clause is used to select the data from table based on various criteria. It allows

Select data from diplicated data
Select data from diplicated data hello i have table location... 5:00 i need to get msce 23:00 how go get like...++) { $SQL = "SELECT duration FROM core_network WHERE location=('".$location_c[$k

i want to select a multiple value of check box by using onclick or onchange event without using from submission
i want to select a multiple value of check box by using onclick or onchange event without using from submission i have 4 check box name 1)profile...)1000-1500 3)1500-2000 4)2000-2500 when i am selecting first value of checkbox

How do I learn Java programming in one day from zero?
How do I learn Java programming in one day from zero? Hi, I am.... Is there any way of really learning Java in one day? How do I learn Java programming in one day from zero? I am aware of C and C++ programming language. I have used

Select tag to fetch data from oracle database
Select tag to fetch data from oracle database I created a select box having more than one menus in the select box such as regnno, address and name... can view the student name. Plz help me.....how to do it in netbeans or myeclipse

how to select second combobox value .
how to select second combobox value . I requirement is , i have two combo box, i am selected first combo box value then automatically second combo box value show ,But this both combo box value i retrieves in database. please

How do I throw a 404 error from within a java servlet?
How do I throw a 404 error from within a java servlet? How you can write code in Servlet for throwing the httpd error 404? How to add the configuration for handling the not found error in the web.xml file? Thanks

SQL Select From
SQL Select From SQL Select From keyword show you the records from a specified table. Understand with Example The Tutorial illustrate an example from 'SQL Select From

How to display all the Select values from the MySQL database table in where condition= In JSP?
How to display all the Select values from the MySQL database table in where condition= In JSP? **Hi in jsp,SQL select statement,i am unable... in the jsp file. @select * from table dept where dept_no=10;" jsp code i have used

How can i select a particular item in jpopup menu through java programs
How can i select a particular item in jpopup menu through java programs Good day Friends .... I have a doubt in jpopupmenu. That how can i sow a perticular menu item in jpopup menu to be selected. I created a gui where it has

Select string from array in objective c
Select string from array in objective c Hi, I wanted to select a string from the database table in objective c. But somehow it is not working..can...:@"SELECT ic, district, age, race, referralSource, DMRelatedAdmin, postalCode FROM

How to change focus among multiple select boxes?
How to change focus among multiple select boxes? Hello, I have three select boxes in three divs. All of the select boxes are focused when I click... not all. I tried to do this with an example below. But as you will see, select

Select data from Table in Database
Select data from Table in Database ... the selected data from table in database. The select query in the database retrieve...; in simple select statement is given below select column name from table

how to operate on select box using ajax in struts2?
how to operate on select box using ajax in struts2? I am doing a project on struts2 in which i have a jsp page which has two select boxes like Now i want to use ajax so that when i select a district value

select query
select query how to write select query with where clause having multiple variables. example: i want to select the data from DB in which i want to check againest two variable in where cluase. String sql = "select * from

how to operate on select box using ajax in struts2?
how to operate on select box using ajax in struts2? I am doing a project on struts2 in which i have a jsp page which has two select boxes like <... so that when i select a district value it will retrieve me all the blocks under

select result from three tables using sql.
select result from three tables using sql. I want to get a result from three tables. i dont how to write the sql query. Please help me. "I want... asdf 102 007 I am not sure, is it possible. but help me. THANKS

How to give value for select in HTML dynamically using javascript
How to give value for select in HTML dynamically using javascript hi. Consider the situation i am having 2 select options called degree and department. if i select a degree the departments corresponding to that degree only

How do I upgrade mysql?
How do I upgrade mysql? How do I upgrade mysql

help to select a value from the dropdown list
help to select a value from the dropdown list I have a html file... = "SELECT service_type FROM pb_operating_parameters WHERE service_type ILIKE '"+stri...()); } %> Please can someone help me on how to select a value

mysql select into table from another table example
mysql select into table from another table example Can you suggest the correct example of select into table from another table example in MySQL... from one table into another table. Check the example at MySQLselect into new

Ads