Posts

1. WHERE, AND, OR, NOT, IN 2. ORDER BY, ASC, DESC 3. IS NULL 4. LIMIT 5. MIN, MAX, COUNT, AVG, SUM 6. LIKE, WILDCARDS 7. IN BETWEEN 8. JOINs - INNER, LEFT, RIGHT, FULL 9. Subqueries & CTEs 10. UNION 11. GROUP BY 12. HAVING 13. PARTITION BY, OVER 14. LEAD, LAG 15. RANK, DENSE_RANK, PERCENT_RANK 16. ROW_NUMBER, CUME_DIST 17. FIRST_VALUE, LAST_VALUE

0

Write a sql query to find the second largest number from table table_name and column number.

0

SQL What is the correct order of execution ?

0

WRITE A QUERY TO OUTPUT THE APARTMENTS WHOSE PRICES ARE GREATER THAN THE AVERAGE AND ARE ALSO NOT RENTED ,SORTED BY PRICE COLUMN

0

Software Engineer (Firmware) – 2021 Passout

0

Cognizant Campus HR team – Hiring for Graduate Trainee/ immediate Biz requirements (Any 3 year graduates: 2018, 2019, 2020 & 2021 batch)

0

PayMe India app for an instant loans up to Rs. 2,00,000 with flexible repayment options. Check out here

0

PAYZAPP

0

CIBIL REPORT AND CBIL CORRECTION

0

Tipu Sultan Fort

0

Puzzle: Suppose there are 4 people and they want to pass through a bridge. Only 2 people can go through a bridge at a time and they can travel through a bridge only with a torch and they have only one torch with themselves. Find the minimum time required to pass the bridge by four of them. 1st person takes 1 min, 2nd takes 2 min, 3rd takes 5 min, 4th takes 10 min.

0

Top 9 Python Libraries for Machine Learning in 2021NumPy.SciPy.Scikit-learn.Theano.TensorFlow.Keras.PyTorch.Pandas.

0

SQL BASICS

0