Transact-SQL Desk Reference

24 Jan 2020 ... In this tip we look at the impact of building SQL Server indexes in ascending ... This can be done simply by using the key word ASC or DESC when ... Don't worry so much about creating your single column index in ... For example Order is sortered by Date, OrderId, Reference and for example by CreatedBy. Comprehensive, community-driven list of essential SQL interview questions. ... As such, it will refer to the envelope table comparing itself to itself! ... Considering the database schema displayed in the SQLServer-style diagram below, write a SQL query to return a list of all ... select empName from Employee order by 2 desc;.