How To execute this Query In lIferay?

[8年前 に Bharamani P Tashildar によって更新されました。]

How to execute below query in liferay.........


SELECT qualityId FROM `quality_quality`
ORDER BY qualityId DESC
LIMIT 1;

I am trying to get last Primary key from table.........
If any other APIs available please tell me


Thanks
Bharamani

[8年前 に Samuel Kong によって更新されました。]

You can use a custom SQL query.

[8年前 に Harsh Joshi によって更新されました。]

liferay provides Dynamic Queries
you can do from this

[8年前 に David H Nebinger によって更新されました。]

Harsh Joshi:

liferay provides Dynamic Queries
you can do from this

That's helpful.

You could have at least pointed out to the guy that his SQL skills are less than adequate. His query should be "select max(quantityId) from quantity_quantity" yet he's sorting, using a row limit, ...

Total crap.