1 Answer - Sort by: Date | Rating
Query languages can be used to retrieve and manipulate data stored in databases and information systems, for example requesting employee or medical records, or recording the sale of a product.
Type "Query language" in wikipedia.org and they have a nice listing of querying languages and their uses.
One example of a database engine and querying language is the open source MySQL, popular in web applications. Say I had a table in a database that contained employee details (ID, name, email address, date of hire, etc.). If I wanted to retrieve a list of the employee records that included only the employee ID and name, and only employees hired before January 1 2008, the database query might look like:
Select employee_id, employee_name from t_employees where date_hired < 2008-01-01, order by employee_name;
You can also use the language to request changes to be made to the information repository. For example, a new employee was hired:
Insert into t_employees (employee_name, date_hired) VALUES
('Jane Doe', '2009-05-01');
Type "Query language" in wikipedia.org and they have a nice listing of querying languages and their uses.
One example of a database engine and querying language is the open source MySQL, popular in web applications. Say I had a table in a database that contained employee details (ID, name, email address, date of hire, etc.). If I wanted to retrieve a list of the employee records that included only the employee ID and name, and only employees hired before January 1 2008, the database query might look like:
Select employee_id, employee_name from t_employees where date_hired < 2008-01-01, order by employee_name;
You can also use the language to request changes to be made to the information repository. For example, a new employee was hired:
Insert into t_employees (employee_name, date_hired) VALUES
('Jane Doe', '2009-05-01');
0
0
- What Sport Would A Typical Upper Class Member Take Part In?
- Explain The Function Of Each Phase Of Compiler In Brief. Illustrate The Transaction Of The Following Statement On All The Phases Of Compiler – A = B*C+D/E?
- What Is The Difference Between C And C++ And Java?
- Why Overriding In Java?
- How To Use My Programming Skill In Banking?
- How Do I Manually Program My Audiovox 8910?
- What Are The Syntax Of JAVA Programming Language?
- What Is Structure In C Language?
- What Is For Loop?
- What Is A Loop Arch And Whorl?
- Define The Difference Between Logical And Physical Data Views?
- What Types Of Programming Language Statements Are Likely To Be Translated Into Machine Instructions By A Compiler?
- How Middleware Works Between Client And Server?
- Can You Give Me An Sample Program Of A Magic Square?
- Obtain An Inherit Ant Hierarchy For The Following In The Kitchen Super Class, Class Object For The Following: Book,viral Infection,rodents?
- What Is Table,cell,row And Columns In MS Word?
- Example Program To Fill Elements Into A List. Also, Copy Them In Reverse Order Into Another List?
- How To Create A Java Program That Accepts A Number And Examines If It Is Odd Or Even And Positive Or Negative?
- How To Create A Java Program That Accepts 3 Numbers?
- How Does An Assembler Works In Assembly Language?
- Can You Create A Java Program That Accepts 3 Numbers (num1, Num2, Num3) And Sort Them In Ascending And Descending Order?
- What Are Some Errors In Using Database?
- What Is A Ground Loop?
- An Sql Server Is Not An Operating System... why Are People Always Asking Exam Questions On This Site?
- Select A Third-party Control Available For Visual Basic.NET. Discuss How This Control Is Used In An Application. What Are The Advantages And Disadvantages Of Using Third-party Controls In Your Applications?
- Which Sort Of Query Languages Is Being Used Nowadays?
- What Is A Query? Where And Why It Is Used?
- What Does Query Mean?
- How Do I Do A Crosstab Query?
- Can Someone Help With My Pregnancy Query?
- What Does Query Means?
- Why Was My Query Disapproved?
- In Software Terminology What Is A Query?
- What Is Query? Discuss Its Uses And Advantages?

New Comment - Comments are editable for 5 min.