Learn Oracle Developer from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

SQL - Structured Query Language - DQL Commands - SELECT

Kasyap Kasyap
29/12/2016 0 1

Structured Query Language allows to store , manipulate, control and retrieve the information from Relational Database Management Systems. Following are some RDBMS products. Oracle Databse, Microsoft SQL Server, MySQL, PostgreSQL etc.

SQL commands can be categorized under

  1. DDL - Data Definition Language      (CREATE, DROP, ALTER)
  2. DML- Data Manipulation Language   (INSERT, DELETE, UPDATE)
  3. DCL- Data Control Language            (GRANT, REVOKE)
  4. DQL- Data Query Language              (SELECT)

In this session we will focus on DQL SELECT Statement

SELECT T2. DepartmentName, T1. StudentName, SUM(MARKS)

FROM Students T1, Departments T2, MARKS T3




GROUP BY  T2. DepartmentName,T1. StudentName


ORDER BY T1.StudentName

 This is old fashioned way of writing clean SQL statements, New way of writing statements to achieve the same result will be discussed in the actual course.

SELECT Clause: Here one has to list the columns in a table(s) to display as a result of the query. columns can be from the list of tables mentioned in FROM clause. A from clause can have a sub query instead of a physical table or view. we will cover this in detail, don't get lost. We can also use Oracle functions or custom functions to return single value return functions.

FROM Clause: This is to include the tables and optionally subqueries (logical table with in memory)

WHERE Clauase: This is to filter the results of the entire select statement. you can exclude or include certain criteria. Apart from this you also join other tables with appropriate unique column to match appropriate record/row with appropriate record/ row in other table.

GROUP BY Clause: This is to group set of columns to use aggregate functions. example Average sales by city or state etc.

HAVING Clause: This is to filter the group results, unlike where cluase it is applied at the group result. example Average Sales > 10000.

ORDER BY Clause: This is to sort the results using specific selected list of the columns in SELECT clause.

0 Dislike
Follow 1

Please Enter a comment



Aditi | 05/01/2021

Thanks a lot!

0 0

Other Lessons for You

Sub Queries in SQL(Structured Query Language)
Writing the Query in one more Query is called Sub Query. In Oracle SQl Sub Queries are Diveded into two categories Simple Sub Queries Cor-related Sub Queries The difference between Simple Sub Queries...

How To Return a Result Set from a Stored Procedure
One of the easiest ways to tackle such Real Time scenarios is through use of Oracle Defined "SYS_REFCURSOR" or "REF CURSOR". We can create a Procedure with an out parameter of Type SYS_REFCURSOR and in...

Exception Handling topics
Here, I am only going to list the topics which one should consider to master Exception Handling. 1. Types of errors in Pl/sql- Compile time and Run time 2. How to read and understand the Compile time...

How To Create The Java Souce In Oracle PLSQL?
Requirement: How to find the list of files in specified directory? Step1 : First find the JDK Install or not in the oracle, to find jdk version please run the below sql. SELECT dbms_java.get_ojvm_property(PROPSTRING=>'java.version')...

Starter on exception handling
Just run these two blocks individually, observe the output and comment on what do you understand from it. SET SERVEROUTPUT ONDeclareCursor C is select * from emp;i c%rowtype;BeginFetch C into i;End; SET...

Looking for Oracle Developer ?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Looking for Oracle Developer Classes?

The best tutors for Oracle Developer Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Oracle Developer with the Best Tutors

The best Tutors for Oracle Developer Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more