Skip to main content

Capabilities of SQL SELECT Statements

A SELECT statement retrieves information from the database. You can do the following:

Projection: You can use the projection capability in SQL to choose the columns in a table that
you want returned by your query. You can choose as few or as many columns of the table as
you require.

 Selection: You can use the selection capability in SQL to choose the rows in a table that you
want returned by a query. You can use various criteria to restrict the rows that you see.

Joining: You can use the join capability in SQL to bring together data that is stored in different
tables by creating a link between them. Here Link is nothing but joining tables.

Comments

Post a Comment

Popular posts from this blog

Oracle Developer Technical Interview Questions

Here i am putting all the questions i had faced during my interviews ... Interview at “3i InfoTech”, Chennai:  1) What is flow of execution of WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, and WHEN-NEW-ITEM-INSTANCE? 2) What is PRE-QUERY and POST-QUERY? When these triggers will fire? 3) If the object library with some blocks and triggers if a form inherited that object library if u doesn’t need some trigger to be inherited the can u delete that trigger from that form? 4) How u can call a report from a form? Which property u has set in runtime? 5) If u create a relation between two blocks in the form what are all triggers it will create? 6) What is a ref cursor? 7) To call a form which type of built-ins u has to use? 8) What is the main difference between expand and variable property for a text item in reports. 9) In a report layout there is accepted and rejected fields and it has a parameter when u run the report based on the parameter the output should sh...
Post a Comment
Read more

Communicating with a RDBMS Using SQL

What is SQL? SQL Stands for Structured Query Language. I t is the  international  standard language for relational database management systems. It is useful for  accessing and manipulating data in a databases.  To access the database, you execute a structured query language (SQL) statement, which is the American National Standards Institute (ANSI) standard language for operating relational databases.
Post a Comment
Read more

Difference Between CASE and DECODE?

– CASE is a expression – DECODE is a function - CASE expression is ANSI SQL Statement - DECODE is specific to Oracle Syntax - CASE syntax contains WHEN and THEN  - DECODE will not have this - CASE allow expressions or Scalar Sub query Expressions inside the CASE statement - DECODE won't allow expressions inside the DECODE function
1 comment
Read more