Replace Employee with your table name, and Salary with your column name. Where N is the level of Salary to be determined. Let us see a query to retrieve the Nth Maximum Value.
SQL SERVER – Locking Hints and Examples
Locking Hints and Examples are as follows. The usage of them is the same but the effect is different. Let us learn it today together.
SQL SERVER – SELECT vs. SET Performance Comparison
Usage: SELECT : Designed to return data. SET : Designed to assign values to local variables. While testing the performance of the following two scripts in query analyzer, interesting results are discovered. SET @foo1 = 1; SET @foo2 = 2; SET @foo3 = 3; SELECT @foo1 = 1, @foo2 =…
Read More