I was given an image of a sql database model and asked to extract information from it. how do i convert or transcribe the image into something I can do this with? I don’t know what to try because the…
lets get to the situation quickly, so i have a table which contains values as id f_name l_name phone 1 rohan mehra 9090909090 2 yusuf yohana 1010101010 3 rohan mehra 9090909090 4 yusuf yohana 1010101010 so if yu observe, there…
I have a SQL table with the following data: | Name | Colour | Shape | | -------- | ------------------ | ---------------- | | Bob | Blue, Green | Circle, Square | | Phil | Yellow | | | Steve…
I am updating a table with the primary key of another table, based on some join condition. The problem is that when multiple rows of the 1st table match with 1 row of the 2nd table, all the rows of…
I have the following table, lets call this table_a: Zone vehicle_name vehicle_status A BusA1 Start A BusA2 Start A BusA3 Stopped B BoatB1 Ready B BoatB2 Stopped B BoatB3 Start C CarC1 Ready C CarC2 Ready C CarC3 Stopped I…
This is the code for Select options: <div class="modal-body row"> <form role="form" action="patient/addNew" class="clearfix" method="post" enctype="multipart/form-data"> <div class="form-group col-md-6"> <label for="exampleInputEmail1"><?php echo lang('categorie'); ?></label> <select class="form-control m-bot15" name="categorie" value='' id="p_category"> <option value="#"> Sélectionner catégorie</option> <?php foreach ($categories as $category) {…
created_date rake_device rounded_geo_lat rounded_geo_lng idle_or_moving new_idle_moving 08-01-2024 11:27 a-b 28.29 76.39 idle idle 08-01-2024 10:27 a-b 28.29 76.39 idle idle 08-01-2024 09:27 a-b 28.29 76.39 idle idle 08-01-2024 08:27 a-b 28.29 76.39 idle idle 08-01-2024 07:27 a-b 28.29 76.39 idle…
I have 3 tables : accounts, contacts, contact_activity. Accounts can have multiple contacts, also multiple activities whereas contacts can also have multiple activities. adding tables queries below: CREATE TABLE `accounts` ( `id` int(10) UNSIGNED NOT NULL, `companyName` varchar(255) COLLATE utf8mb4_unicode_ci…
I want to make a result from query after distinct and groupby This is My Code $results = DB::table('dokumen') ->join('pengadaan', 'dokumen.id_jenis_pengadaan', '=', 'pengadaan.id') ->select( DB::raw('COUNT(nama_paket) AS jml'), DB::raw('jenis_pengadaan as jenis_pengadaan'), DB::raw('tahun as tahun') ) ->groupBy('jenis_pengadaan', 'tahun') ->orderBy('tahun') ->get(); $hasil =…
I have two queries that I’m trying to combine, but I’m having an issue and I believe it has to do with the GROUP BY Date when I do LEFT JOIN. The date formats are the same and the only…