Query:

SELECT * FROM EMPLOYEE1;

Select 5 columns and all rows from one table

Query:

SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

 

Posted Date: 3/14/2013 1:58:42 AM | Location : United States

Ask an Expert

Related Discussions:- Select query, Assignment Help, Ask Question on Select query, Get Answer, Expert's Help, Select query Discussions

Write discussion on Select query
Your posts are moderated

Write your message here..

Related Questions

Initializing records, Initializing Records The illustration below show... Initializing Records The illustration below shows that you can initialize a record in its type definition. Whenever you declare a record of the type TimeRec, its 3 fields supp

Sqls counterpart of the key words, SQLs counterpart of the key words: ... SQLs counterpart of the key words: The text from the opening parenthesis to the end of the fourth line specifies the declared type of the table, meaning that every table ever

Exit statement - syntax, EXIT Statement   You can use the EXIT stateme... EXIT Statement   You can use the EXIT statement to exit a loop. The EXIT statement has 2 forms: the conditional EXIT WHEN and the unconditional EXIT. With the either form, you

Ending transactions, Ending Transactions A good quality programming pr... Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

Restriction in sql, Restriction in SQL Syntax: SELECT DISTINCT... Restriction in SQL Syntax: SELECT DISTINCT StudentId FROM IS_CALLED WHERE Name = 'Boris' The WHERE clause operates on the result of the FROM clause in analogo

Referencing records, Referencing Records Unlike the elements in a coll... Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Definition of cross join - sql, Definition of CROSS JOIN - SQL Let s ... Definition of CROSS JOIN - SQL Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then: Note: Here T denotes Table

Logical operators-pl/sql expressions , Logical Operators The logical op... Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Literals in pl/sql, Literals A literal is an explicit numeric, string... Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of

Relational algebra, Define basic operators of relational algebra with an ex... Define basic operators of relational algebra with an example each