ganesh kavharSQL Check ConstraintCheck constraint manage the condition the values enter into record. if the condition evaluates as false, it violates the applied condition.Dec 28, 2022Dec 28, 2022
ganesh kavharSQL Best PracticesSELECT first_name || ‘ ‘ || last_name || ‘, ‘||job_id EMP FROM employees;Jun 6, 2022Jun 6, 2022
ganesh kavharSQL BEST PRACTICESWRITE A QUERY TO PRINT ALPHABETS FROM A TO Z IN SQL ?May 9, 2022May 9, 2022
ganesh kavharSQL Practice Set 1— To fetch ALTERNATE records from a table. (EVEN NUMBERED) SELECT * FROM (SELECT ROWNUM AS RN,E.* FROM EMPLOYEES E) WHERE MOD(RN,2)=0;Mar 14, 2022Mar 14, 2022
ganesh kavharSQL Group By Clause ExerciseQ1.display total number of employees work in each departments? SELECT DEPARTMENT_ID,COUNT(*) FROM EMPLOYEES GROUP BY DEPARTMENT_ID;Mar 3, 2022Mar 3, 2022
