Posts

Drop table in a database using drop statement.

Rename column name of a table using Alter statement.

Update data in table using update statement.

Create Table, insert data and query data from table

How to Perform RowNumber on SQL query

Perform Dense Rank on SQL Query.

How to create Table a table in oracle or MSSQL or SQLServer.

Group by in SQL query

How to find 2nd or Nth highest salary using SQL query window functions