Learn Oracle Developer from the Best Tutors
Search in
Lesson Posted on 29/12/2016 Learn Oracle Developer
SQL - Structured Query Language - DQL Commands - SELECT
Kasyap Kasyap
My Experience : 10+ years experience on Oracle Applications / E-Business Suite Implementation Projects 6+...
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
In this session we will focus on DQL SELECT Statement
SELECT T2. DepartmentName, T1. StudentName, SUM(MARKS)
FROM Students T1, Departments T2, MARKS T3
WHERE T1.DEPTCODE=T2.DEPTCODE
AND T1.STUDENTID=T3.STUDENTID
AND T3.EXAMNAME='SEMESTER 1'
GROUP BY T2. DepartmentName,T1. StudentName
HAVING SUM(MARKS)> 900
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.
read lessAnswered on 02/12/2016 Learn Oracle Developer OCA
Kasyap Kasyap
Oracle Technical Consultant
Lesson Posted on 01/09/2016 Learn Oracle Developer
Praneeth Vasantha
I have 10 years of real time experience in Oracle SQL and PL/SQL. Will provide good notes and interview...
Learn Oracle Developer from the Best Tutors
Answered on 25/01/2016 Learn Oracle Developer OCA
Deepak
Oracle Database Trainer
Answered on 05/02/2016 Learn Oracle Developer OCA
Deepak
Oracle Database Trainer
Answered on 04/12/2015 Learn Oracle Developer OCA
Aashish Kumar
Informatica/Oracle Trainer
Learn Oracle Developer from the Best Tutors
Answered on 15/02/2016 Learn Oracle Developer OCP
Raghavendra Rao
Senior Oracle Developer
Answered on 19/01/2016 Learn Oracle Developer OCP
Deepak
Oracle Database Trainer
Answered on 06/12/2015 Learn Oracle Developer OCM
Neeraj A
Learn Oracle Developer from the Best Tutors
Answered on 06/12/2015 Learn Oracle Developer OCM
Neeraj A
UrbanPro.com helps you to connect with the best Oracle Developer in India. Post Your Requirement today and get connected.
Ask a Question
The best tutors for Oracle Developer Classes are on UrbanPro
The best Tutors for Oracle Developer Classes are on UrbanPro