| |
* Find n th Highest Salary
:
to find ‘n’ th highest salary from a Table.
|
* Count, Find, Delete Duplicate Rows
:
How to Find, Count and Delete Duplicate Rows
|
* Sort Rows in Specific Order
:
Ascending, Descending, Specific Order
|
* Generate CSV
:
to Generate Comma Separated Values(CSV) from Query
|
* Rotate Columns into Rows
:
Rotate Table
|
* Display Row Numbers
:
Display data with Row Numbers
|
* Find Max, Min Values in a Row
:
how to find Max and Min Values in a Row of a Table
|
* Arrays in SQL
:
how to use Arrays in T-SQL
|
* Generate Random/Lottery Nos
:
how to Generate Random/Lottery Nos
|
* Select TOP n Rows For Each Group
:
How to Select TOP n Rows For Each Group
|
* Find Data Between Two Dates
:
How to Find Rows Between Two Dates
|
* PIVOT and UNPIVOT Data
:
How to PIVOT and UNPIVOT Data
|
* IMP Queries
:
Display data with Row Numbers
|