student_doubt/join
https://stackoverflow.com/questions/43821291/is-it-possible-to-make-shortcut-icon-round-using-css
https://stackoverflow.com/questions/65729652/is-there-a-way-to-change-the-border-radius-of-a-favicon-icon
https://www.geeksforgeeks.org/top-10-new-features-of-html5/
select * from employee_records order by employee_designation desc
SELECT DISTINCT(employee_designation) from employee_records
SELECT count(employee_id) ,employee_designation from employee_records group by employee_designation
SELECT count(employee_id) ,employee_designation from employee_records group by employee_designation
having COUNT(employee_designation)>1
join :--
inner join
SELECT employee_name,employee_attendance FROM employee_records inner join employee_attendance on employee_attendance.employee_id=employee_records.employee_id
left join
SELECT employee_name,employee_attendance FROM employee_records left join employee_attendance on employee_attendance.employee_id=employee_records.employee_id
Comments
Post a Comment