1. select product_id from products where low_fats = 'Y' && recyclable = 'Y' ; 2. select name from customer where referee_id != 2 || referee_id is null ; 3. select name, population , area from world where area > 3000000 or population > 25000000 ; 4. select distinct author_id as id from Views where author_id = viewer_id order by id; 5. select tweet_id from tweets where char_length (content) > 15 ; 6. select unique_id, name from Employees left join EmployeeUNI on Employees.id = EmployeeUNI.id; 7. select customer_id , count (visits.visit_id) as count_no_trans from visits left join transactions on visits.visit_id = transactions.visit_id where transaction_id is null group by customer_id; 8. SELECT w1.id FROM Weather w1, Weather w2 WHERE DATEDIFF(w1.recordDate, w2.recordDate) = 1 AND w1.temperature > w2.temperature;
1. for table use protected $table = "mytablename" ; 2. difference between post from web and api . sol. @csrf token 3. diff web.php and api.php sol. https://koenwoortman.com/laravel-difference-between-web-and-api-routes/ 4. many to many relation 5. patch and put = multiple column update in put and update single column in patch . 6. show single variable in all view files. sol: https://stackoverflow.com/questions/32683069/how-to-make-a-variable-available-to-all-my-pages-in-laravel 7. how many table use in one to one one to many many to many
Comments
Post a Comment