我想将一个变量名连接到我的SQL查询中,用于order by,如下所示。 我基本上不想使用动态sql、exec和sp_executesql。DECLARE @Order VARCHAR(1000) SET @Order = 'CO_ID DESC‘print @Order select * From contact where co_username= 'sandeepshm’order by @Order
我希望所有的广告都是按价格排序的。我有两个模型和表格:公告和费率。Announcement.find_by_sql 'select * from announcements ann inner join rates r on ann.id = r.announcement_idorder by r.average DESC'Announcement.paginate :page => params[:page], :per_page => 10, :include=> [:rates]