GA1 SQL.docx - GA1 Question 1 The obvious difference is in...

GA1

Question 1
The obvious difference is in what they are designed for: SQL is a query language used for
manipulating statistics saved in a database. T-SQL is also a query language, but it's an extension of
SQL that is notably used in Microsoft SQL Server databases and software.
Question 2
The first noticeable component of SQL that is unique than other programming languages is the order
in which the code is processed. It is not a programming language. It “Relational Algebra.” There is no
go with the flow of control. It is series of information identifications of tables and columns within
tables and logical equations that constrain the selection of information rows. It is logical
programming of facts selection. It is closer to Prolog than any different programming language.
Question 3
The ORDER BY key-word is used to sort the result-set in ascending or descending order. The ORDER
BY keyword varieties the files in ascending order through default. To type the archives in descending
order, use the DESC keyword.The WHERE clause is used to filter records. It is used to extract only
these data that fulfill a certain condition.