Self join Example

Display the hierarchy of all employees with rank

Create employee table

create table emp(
        id int,
                    fname varchar(16),
                    lname varchar(16),
                    e_level int
);

Insert data

joins.xlsx

Feature	sort()	sorted()
Works on	Lists only	Any iterable (lists, tuples, dictionaries, strings, etc.)
Returns	None	New sorted list
Modifies original?	Yes (in-place)	No
Usage	list.sort()	sorted(iterable)

sort() example

numbers = [4, 1, 3, 2]
numbers.sort()
print(numbers)  # Output: [1, 2, 3, 4]

sorted()

Read More