Have Queries? Ask us +91 75065 23339

Reporting Aggregate Data Using the Group Function

Posted by admin on 
March 17, 2017

0

Category: sql
  • Group Functions MIN
  • MAX, COUNT, AVG,DISTINCT within group functions
  • NULL values in a group functions

Displaying Data from Multiple Tables

Posted by admin on 
March 17, 2017

0

Category: sql
  • Types of JOINS
  • Natural join
  • Self-Join
  • Non-equijoin
  • Outer join
  • Cartesian Products

Using Subquery

Posted by admin on 
March 17, 2017

0

Category: sql
  • Single row subquery
  • Group Function in subquery
  • HAVING clause with subquery
  • Multiple-row subquery
  • NULL values in Subquery

Using Set Operator

Posted by admin on 
March 17, 2017

0

Category: sql
  • UNION and UNION ALL
  • INTERSECT
  • MINUS
  • ORDER BY clause

Manipulating Data

Posted by admin on 
March 17, 2017

0

Category: sql
  • INSERT, UPDATE, DELETE
  • TRUNCATE and COMMIT
  • ROLLBACK and SAVEPOINT
  • Read consistency
  • FOR UPDATE clause

Leave A Reply

Your email address will not be published. Required fields are marked *

[mc4wp_form id=”2142″]

Contact Us
close slider



Request a Demo

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

Your Name (required)

Your Email (required)

Your Mobile Number (required)

Subject
OnlineOffline

Your Message

X