SQL Search Data

OBJECTIVE

In this chapter you will learn:

About search data
Example of search data

 

Search data

If you want to search data according to some specific condition then you can use some statements with like, wildcards and aliases. The two commands like and wildcards used with SQL statements to retrieve specific data and aliases is laso to do same function but it is mainly used whey user join tables based on common columns which has same column name.

 

Example of search data

1. like:- Used to search specific data with where clause with the help of wildcards.
2. wildcards:- Helps to search data with like statemenet
3. aliases:- Used to uniquely identify the table and defined in FROM clause of the SELECT statement.

Search data statements

Statements

SUMMARY

In the given chapter you have laerned about search data and its commands so in the next chapter you will laern about all commands. Click on the nest button to know anout like statement in details with example.


Leave a Reply

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