Sunday, 17 March 2013
SQL: OR Command
Do you like this Article?
Syntax: SELECT [column_name] FROM [table_name] WHERE [condition_1] OR [condition_2];
Here, output will come if [condition_1] OR [condition_2] OR both satisfied. That means, it is SELECT [column_name] FROM [table_name] WHERE [condition_1] OR [condition_2] OR both applied.
Example:
Again, we will use the same table, to see the usage of OR command.
Table Name:
Employee Details ( employee_details)
Column Names:
Employee ID ( emp_id),
Employee Name (emp_name),
Employee Address (emp_address) and
Employee Role: (emp_role).
Table: employee_details
Now, using OR command, we will SELECT those tuple, WHERE emp_role is 'Developer' or 'Business Analyst'.
So, the query will be :
SELECT * FROM employee_details WHERE emp_role = 'Developer' OR emp_role = 'Business Analyst';
Result:
Subscribe to:
Post Comments
(
Atom
)
Popular Posts
-
public - public means everyone can access it.That means it's in global scope. As, main method is called by JVM [ Java Virtual Machine...
-
throw is used to throw an exception in a program, explicitly . Whereas, throws is included in the method's declaration part, wi...
-
Singleton in one of the most popular yet controversial design pattern, in the world of object oriented programming. It's one of t...
-
Web Container / Servlet Container / Servlet Engine : In J2EE Architecture , a web container (also known as servlet container or ser...
-
Program compiles. But at runtime throws an error “NoSuchMethodError”.
-
Vector : It's synchronized. It's slower than ArrayList. It's generally used in ...
-
doGet(): protected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, java.io.IOException – is a met...
-
In Java Programming Language , we must declare a variable name and type, before using it. The data type of a variable defines the th...
0 Responses to “ SQL: OR Command ”
Post a Comment