Tag: Queries

SQL DISTINCT

In this tutorial post, we are going discussing how to Eliminating Duplicate Records from the table. SQL DISTINCT The table could have duplicate row. In such case how to view only unique rows i.e distinct rows to achieve it DISTINCT clause can be used. The DISTINCT clause can be used to removing duplicate records from […]

SQL WHERE

SQL WHERE Statement In this tutorial post, we are going to discussing SQL WHERE statement in oracle data base. Oracle provides the option of using WHERE statement in an SQL query to apply a filter on the rows retrieved. When a WHERE clause is added to the SQL query, then query executing as follows. The […]

SQL SELECT

In this tutorial post, we are going to discussing SQL SELECT statement in oracle data base. Consider we have EMPLOYEE demo table which is using for the executing SELECT command. EMP_ID EMP_NAME EMP_DESIGNATION EMP_GENDER EMP_QUALIFICATION EMP_LOCATION 100 Narayanaswamy Sr.Software Engineer Male MCA Chennai 101 Kumar Quality Analyst Male B.Tech Chennai 102 Ramesh Database Administration Male B.Tech […]