0
An SQL statement is a complete set of clauses which returns a value and ends with a semicolon(;)
A statement is made up of several clauses
Ex: select * from person where f_name='me';
In this ex ' select * from person where f_name='me';' is the statement and select*, from person, where f_name= are the clauses
Add your answer:
Earn +20 pts
What is the difference between T-sql and sql?
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
What is the difference between quel SQL and qbe?
gand maro...is the answer
Difference between alter and update commands in sql?
Update and Alter are two SQL (Structured Query Language) commands used for modifying databases. Update statement is used to update existing records in a database. Update is a Data Manipulation Language (DML) statement. Alter SQL command is used to modify, delete or add a column to an existing table in a database. Alter is a Data Definition Language (DDL) statement.Commands that are used to define the structure of a database (database schema) are called DDL statements.
Difference between SQL and OQL?
in some cease both are the same they use query language but in fact the out puts are very deference
What is the difference between catalog schema and database in SQL Server?
A catalog is simple a group of related schema collected together in a defined namespace. While schema is a group of one or more related object collected in a common namespace.
What keyword in an SQL statement's WHERE clause is used to select rows based on a range of values?
BETWEEN For example: SELECT columnName FROM tableName WHERE columnName BETWEEN '1' AND '20'
What is the general format of an SQL query?
In general, SQL "statements" have a Select "clause," a From "clause," and a Where "clause."
What is use of IN clause and between clause in sql?
It allows you to easily test if an expression is within a range of values (inclusive).
What basic clause in an SQL statement is used to retrieve rows and columns from tables?
The SELECT clause is used to retrieve rows and columns from tables. Ex: Select * from employee
What is the difference between T-sql and sql?
T-SQL is Microsoft's version of the generic SQL langauge to be used with, for example, Microsoft SQL Server.
What is the difference between hql and sql?
one of the difference is HQL does not support distinct but SQL supports the distinct in the query
What are the differences between SQL statement to iSQL plus statement?
Structured Query Lanaguage(SQL) is a command language to communicate with oracle server.whereas SQL*PLUS is an oracle tool that recognises and submits sql statements to the oracle server for execution.
What does the SQL FROM clause do?
mmm
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
Sql statement for retrieving data between two dates in SQL Server?
SELECT aFieldName, someOtherFieldName, yetAnotherFieldName FROM aTableName WHERE fieldNameWithDateInIt BETWEEN date1 and date2
Difference between sql server 2003 sql server 2005?
There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.
What is the difference between quel SQL and qbe?
gand maro...is the answer
