Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links

What is a query in database?

By Arsal Ahmed   Posted on March-20-2018   516

A query is an inquiry into the database using the SELECT statement. A query is used to extract data from the database in a readable format according to the user's request.

For instance, if you have an employee table, you might issue a SQL statement that returns the employee who is paid the most. This request to the database for usable employee information is a typical query that can be performed in a relational database.

A SQL SELECT statement can be broken down into numerous elements, each beginning with a keyword. Although it is not necessary, common convention is to write these keywords in all capital letters. In this article, we will focus on the most fundamental and common elements of a SELECT statement, namely

  • SELECT
  • FROM
  • WHERE
  • ORDER BY

By Arsal Ahmed    20-Mar-2018 Views  516



You may also read following recent articles