Write a program for find largest second number from list

l =[10,20,30,30,30,40,4,4,4,4]

max1 = l[0]

smax = l[0]

for i in l:

    if i>max1:

        smax = max1

        max1 = i

    elif smax<i and i!=max1:

        smax = i

OR

def secondmax(l):

  list1 = [i for i in l if i < max(l)]

  return max(list1)

secondmax([10,20,30,30,30,4,4,4,4,4])

Write a query to fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains five alphabets.

Select * from employee

Where ename like ‘%a’  and CHAR_LENGTH(ename) = 5;

how to calculate even and odd records form table?

Query to find even record:

SELECT * FROM EMPLOYEE

WHERE id IN(SELECT id FROM EMPLOYEE WHERE id%2
= 0)

 Query to find odd record:

SELECT * FROM EMPLOYEE

WHERE id IN(SELECT id FROM EMPLOYEE WHERE id%2
<> 0)

 ‘Write a query to retrieve duplicate records
from a table?

SELECT OrderID, COUNT(OrderID)

FROM Orders

GROUP BY OrderID

HAVING COUNT(OrderID) > 1

Fetch 5th highest the salary without limit
and top

select * from(select ename, salary,
dense_rank() over(order by salary desc)r from Emp) where r=5

Write query for drop duplicate records

Select *, count(id)

From table_name

Group by id

Having count(id)=1

 Now, assume that you have two
tables: “employees” and “salaries”.

The employee table has basic information: ID,
first name, last name, email address, address etc.

Salaries table has employee-id and salary. Query
to be executed is the same: “List names of all the employees

whose salary is greater than or equal to
Rita’s salary”.

ans: select e.first_name from employee e

inner join salary s

on e.id = s.id

where s.salary > = (select s.salary from
employee e

inner join salaries s

on e.id = s.id and e.first_name = ‘reeta’);

•  What is foreign key and primary key
• Why foreign key needed in sql
• what is index in sql
• what view and table and why view is needed in sql
  what is where and group by
• what is metadata
• what is dimensional table
• what is star schema
• aws glue and athena