4 most asked SQL queries during SQL Serverinterview’s

Find second highest from a SQL Server table

Watch this youtube video which discusses about the same

 

How to delete top three rows from a table.

Following query is expected to be working.
             Delete top 3 From MyTable
But it will not, rather it will generate error.Correct query will be
             Delete top (3) from MyTable

Get Top 4 From Every group

Selectm * from
(
             Select *,row_number () over (partition by Grouping_Column1, Grouping_Column2,
Grouping_Column3 order by OrderByColumn desc) RankId from MyTable
) as T
Where T.RankID<=3

Create Exact replica of a table (Make sure rows will not get copied)

Select top 0* into NewTable from OldTable

Read a record randomly using SQL

Select top 1 * from Mytable using newID()

You can also watch our 500 SQL Server interview question videos from www.questpond.com

  

Advertisements

About c# and .NET Interview questions

This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview. Do not forget to watch our Learn step by step video series. Learn MVC in 16 hours:- https://www.youtube.com/watch?v=Lp7nSImO5vk Learn AngularJS Step by Step:- https://www.youtube.com/watch?v=0kmdjqgO9IY Learn Design Pattern in 8 hours:- https://www.youtube.com/watch?v=YDobmucohqk Learn C# and .NET in 60 days:- https://www.youtube.com/watch?v=yh2SrzCkNQA Learn MSBI in 32 hours:- https://www.youtube.com/watch?v=mGPJx3ocFgg Learn SharePoint Step by Step in 8 hours:- https://youtu.be/C2fW76SwJNU
This entry was posted in Uncategorized and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s