i have a table where termid,termversion are two primary key. column present in table - termid,termversion,name
我想选择所有名称为 % AB% 的术语, 结果应该包含每个匹配的术语, 并包含最大版本号 。
示例:
id name ver
1 ABBBB 1
1 ABBBB 2
1 ABBBB 3
2 ABC 1
2 ABC 2
输出应产生输出
1 ABBBB 3
2 ABC 2
I want to write this query in hibernate using Criteria...if any one can suggest me in hibernate then its really good else at least help me in writing the sql query. PS I am using postgresql
我认为这就是你们要找的:
SELECT id, name, MAX(ver)
FROM table
WHERE name ILIKE %AB%
GROUP BY name, id -- I assume: id == id <==> name == name
是吗?
从 mytable 中选择 id, 名称, 最大( ver), 名称如% AB% 组 id, 名称
您可以尝试 sql 命令 。
从表名组的 id 中选择 id, name, max(ver), 名字类似% AB%
我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。
On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...
I ll take the simplest of the SQL functions as an example: CREATE OR REPLACE FUNCTION skater_name_match(INTEGER,VARCHAR) RETURNS BOOL AS $$ SELECT $1 IN (SELECT skaters_skater.competitor_ptr_id ...
I m 在当地网络上运行几台机器,在Salgresql8.3处撰写一份申请。
I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.
Hey, I have 2 tables in PostgreSql: 1 - documents: id, title 2 - updates: id, document_id, date and some data: documents: | 1 | Test Title | updates: | 1 | 1 | 2006-01-01 | | 2 | 1 | 2007-01-01 |...
I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...
I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...