Четверг, 08 Мая 2014 г. 09:44
+ в цитатник
-- SELECT * FROM db_s2front.T$PriceInfoReqLog order by creationDate desc;
-- SELECT max(id) FROM db_s2front.T$PriceInfoReqLog
-- SELECT id,creationDate FROM db_s2front.T$PriceInfoReqLog order by id desc LIMIT 1
-- where id = (SELECT max(id) FROM db_s2front.T$PriceInfoReqLog);
-- order by creationDate desc;
-- select id, bet , creationDate, gameId from db_s2front.T$PriceInfoReqLog order by gameId , creationDate desc
-- select id, bet , max(creationDate) ,gameId
-- from db_s2front.T$PriceInfoReqLog
-- group by gameId
http://www.sql.ru/forum/580229/help-po-selektu#5985168
Метки:
sql
-
Запись понравилась
-
0
Процитировали
-
0
Сохранили
-