Tutorial#16 Execute SQL Select Statement| How to retrieve data from table

In this video, I am explaining Basics select statement (Data Query Langauge(DQL)/Data Retrieval Language(DRL) or we can say that How we can retrieve Data from the database with the help of SQL Select statement Or Select Query

Oracle SQL Practice Question :

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

#SQLPracticeQuestion #equalConnectCoach #OracleSQL

[ashutoshhegde]

Thank you Sir. Your Style is awesome. Your explananation is simple. I am going through your videos as a course and I have promised myself to do 3-5 videos everyday and reach till video number 81 and complete the entire SQL course with you.

[rajnandinikhede]

This is 2021 and I am still learning from this 2018 series. Wonderful, very simple and clear teaching sir.. Thank you so much for this series💙

[nikhillathiya]

best tutorial of ORACLE ever iinn the world

[Soul-zo]

1. select emp_id, salary from employee;
2.select first_name from employee
where departno=10;
3.select department_details from department;
4.select emp_id, first_name, salary from employee;
5.select first_name from employee
where hiredate <'01-JAN-2017';

is this correct query plz tell me

[ajedits]

Hi, the assignment that you have given in this videos that tables we need create or they already exist in the SQL ?

[nikhileshm.s]

I installed Oracle 19C because 11g is not available to download from the website

[modupeadewale]

Hello, the oracle I have was installed by someone for me before I started the tutorials, it does not have the hr data sets, it has only sys and I cannot perform operations such as delete etc... do I need to re install it?, thanks

[krajesh]

Hi sir, In tutorial 16, unable to get the input query for 5th question. please help

5. Select first name of the Employee who hired before 01JAN2017

[priyanshupathak]

Sir, Oracle 19c version me sample data sets(employees, countries, departments etc.) nahi hai practice karne ke liye,
to practice kaha par kar sakte hai iska koi solution hai aapke paas. 🙏🏽

[sourabhkinekar]

Hello sir where I get solution of assignment?

[ajedits]

Hi, the assignment of Tut#16 , out of 5 i am getting the out put for 3 question and No. 2 and 5 i am unable to get can you send that inputs, so that i come to know where i am doing the mistakes ? please

[karthikpolisetty]

What was the command to all the tables in the database like their names
I want list of tables what was the command

[mulivyshnavireddy]

what if there are 3 columns or 2 with same id
how can we writequery

[nehadeshmukh]

hi whayt is 3rd ans of assignment ? pls ans

[nikhileshm.s]

SQL developer says, table or view doesn't exist, when I execute "select*from employees", please help.

[learngeek]

what is MongoDB? Nowadays it is widely used.
why is called No_SQL and different from SQL?

[learngeek]

how to change serial no in data base like i have a table there are three attribute1>serial_no 2>name and 3> location.
I want store new record in table attribute serial no with auto_icremental.
ex:
serial_no name location
156AD vikash hyd
156AE vijay bpl
156AF manoj suj

[CherryCherry-gnhy]

What is the solution for 5th question ?