Write a SQL query for second highest salary

Write a SQL query for second highest salary, Here is the query. To fetch the second highest value from the database table there are several way. Here I have used CO-RELATED Query concept and try to display the data. SQL Query for | Second highest salary Select 3rd highest salary in SQL In above query … Read more

How to write SQL query to Calculate monthly report

How to write SQL query to Calculate monthly report, Here is the steps which you need to follow to get the result. Step1) Create table in your database. Step 2) Attendance is bit column (0,1) 0 – Means employee is absent, 1 Means employee is present on that day. I am interested to create the … Read more