Back to Basics – Series :: Cool links for getting to know about the Different Types of Joins in SQL Server. http://www.c-sharpcorner.com/UploadFile/raj1979/SqlJoins10012008164642PM/SqlJoins.aspx http://programming.top54u.com/post/Types-of-Joins-in-Sql-Server-2005.aspx Have Fun!! Happy Coding!!!
IGate Recruitment, in written test has asked about to write an sql query for finding ‘n’ th highest salary from empolyee table. Here is a quick solution Query for Creating Test Table and inserting dummy data. SQL Query for Retrieving the ‘n’ th largest salary from EMPLOYEE table.