I have two tables Parameters and Share_Details. I have my raw SQL query here and I want to write it in pure Eloquent way. please help.
$shareDetails=DB::select
("SELECT s.id,
share_type,
para_int_1,
para_int_2,
price,
para_name
FROM share_details as s,parameters
where para_type='share'
and para_id=share_type
and startDate=(select max(startdate)
from share_details
where share_type=s.share_type)
group by share_type,
s.id,
para_int_1,
para_int_2,
price,
para_name"); 
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Try something like this:
DB::table('share_details') ->crossJoin('parameters' ->select('share_details.id', 'share_type', 'para_int_1', 'para_int_2', 'price', 'para_name') ->where('para_type','=','share') ->where('para_id','=',DB::raw('share_type')) ->where('startDate','=',function($query) { $query->from('share_details') ->select(DB::raw("'max'(startdate)) ->where('share_type','=',DB::raw('s.share_type')); }) ->groupBy('share_type','share_details.id','para_int_1','para_int_2','price','para_name') ->get();