SQL Server Article(s) Category

Sun, 05 Sep 2010

Category:

ORDER BY items must appear in the select list if SELECT DISTINCT is specified

This article shows how to get rid out this prob "ORDER BY items must appear in the select list if SELECT DISTINCT is specified". This may help you..


About SQL Server:

  Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase.Generically, any database management system (DBMS) that can respond to queries from client machines formatted in the SQL language.
SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. Queries take the form of a command language that lets you select, insert, update, find out the location of data, and so forth. There is also a programming interface.

 

Advertisement