answersLogoWhite

0

AND is an Operator and we use, when both the conditions are to be true.

LIKE is a condition and we use to combine pattern matching characters. (% refers one or more characters and _ (underscore) refers one character) say, select eName, eId, eRole, eSal from the employees where eSal >= 1000 AND eRole like '%Engineer%' Output (e.g:)

{| |- | eName eId eRole eSal Steve Richard E123 Software Engineer 1060 Janet Mayor E069 Senior Software Engineer 4025 |}

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

What are the different sql special operators?

Special operators in sql server in not in between notbetween like not like is null


Where might one go to learn more about SQL IN operators?

One can learn more about the SQL IN operators from the W3Schools website which offers great information and tutorials on many topics related to web design and development. TigZag is quite similar website but offers more advanced knowledge (usually). There is also Beginner SQL Tutorial website and MSDN (the Microsoft Developer Network) website with some advice on these.


List two reasons why null values might be introducedin database?

1. special requirements for its use in SQL joins. 2. special handling required by aggregate functions and SQL grouping operators


What SQL operators can be used to omit records from a search by specifying a not-equal relationship?

NOT


Does the LIKE option allow you to use wildcards on a SQL application?

"Yes you can use wildcards in the LIKE key word for SQL. The wildcard used here will will be the ""%"" character as opposed to the more familiar ""*"" character."


When do you capitalize operator?

Operators are not typically capitalized in programming languages, unless they are part of a language construct or a predefined operator (e.g., "AND" in SQL). It's generally best practice to use operators in lowercase for consistency and readability.


Why do you use Linq over SQL Statements?

The extensibility of the query architecture is used in the LINQ project itself to provide implementations that work over both XML and SQL data. The query operators over XML (LINQ to XML) use an efficient, easy-to-use, in-memory XML facility to provide XPath/XQuery functionality in the host programming language. The query operators over relational data (LINQ to SQL) build on the integration of SQL-based schema definitions into the common language runtime (CLR) type system. This integration provides strong typing over relational data while retaining the expressive power of the relational model and the performance of query evaluation directly in the underlying store.


Can you explain how to use the SELECT statement in SQL to perform mathematical operations on data in a database table?

Yes, in SQL, you can use the SELECT statement along with mathematical operators like , -, , / to perform calculations on data in a database table. For example, you can add, subtract, multiply, or divide values from different columns or apply functions to calculate results. Just include the mathematical operation within the SELECT statement to perform the desired calculation.


How do you use SQL?

You use SQL by issuing commands to an SQL server, either directly by you or by a program you are using.


Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?

SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S


How to define a user defined function in SQL?

Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.


Difference between sql and sql plus?

SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database