SQL SERVER

SQL Server Interview Questions On Query for Experienced

Part 1 : SQL Server Interview Questions On Query for Experienced 31.How to find the duplicate from a table Answer Way 1 : Using group by and having clause Way 2: using Row_number(): REPLACE(): It replaces all the occurrences old string with a new string. LEN(): It returns the length of the passed string. LOWER(): …

SQL Server Interview Questions On Query for Experienced Read More »

60 SQL Server Interview Question on Query for experienced

SQL SERVER

In this post, we will explore 60 SQL Server Interview Question on Query for experienced Part 2 : sql-server-interview-questions-on-query-for-experienced Consider These two tables for All Queries Employess_Details Table Department Table 1. What are alternative of Top clause in SQL Server Answer There are two alternative of Top Clause in SQL server Row_number() Rowcount 2.What is …

60 SQL Server Interview Question on Query for experienced Read More »