SQL

Latest SQL News

Latest 4 Key Difference between Rowid and RowNum

Here is the 4 Key Difference between ROWID and ROWNUM : ROWID

etldevloper etldevloper

SQL Query to Find employee with MAX salary department wise – 1

SQL Query to Find employee with MAX salary department wise SELECT *

etldevloper etldevloper

Find the oldest joinee department wise using LEAD Analytic function

Find the oldest joinee department wise using LEAD Analytic function LEAD is

etldevloper etldevloper

SQL Query to Find employee with MIN salary department wise

SQL Query to Find employee with MIN salary department wise SELECT *

etldevloper etldevloper

Find the difference between the salary of an employee and max salary of the employee in the department

Find the difference between the salary of an employee and max salary

etldevloper etldevloper

Find employee with MAX salary department wise without using RANK or DENSE_RANK

Find employee with MAX salary department wise without using RANK or DENSE_RANK

etldevloper etldevloper

Difference Between DROP DELETE and TRUNCATE

Difference Between DROP DELETE and TRUNCATE In SQL DELETE, DROP & TRUNCATE commands

etldevloper etldevloper