Find Nth highest salary using RANKING functions
Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...
2012-12-19
50,161 reads
Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...
2012-12-19
50,161 reads
Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....
2012-12-10
1,307 reads
Sending
Querying Data on Mail:
Sometimes we need to send data fetched from query on
mail automatically. You can
create report and after running...
2012-12-07
724 reads
Linked Server
Setup with Oracle in SQL Server:
Suppose you want to access data from
oracle or other database products using T-SQL via...
2012-10-23
2,240 reads
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2012-09-29
1,400 reads
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2012-09-29
1,271 reads
Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect...
2012-09-22
873 reads
Querying Microsoft SQL Server : Data Types in SQL Server: Data Type Description Remarks BIGINT Used for large Integer data.(Range -2^63 ...
2012-09-22
386 reads
Functions in SQL Server: Functions in SQL Server In SQL Server functions are subrotienes that encapsulate a group of T-SQL...
2012-09-22
593 reads
Error Handling in T-SQL: Error handling in T-SQL: Error handling in T-SQL is similer to other programming languages as C#,C++,Java.A...
2012-09-22
619 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers