Condition (SQL)

to get instant updates about 'Condition (SQL)' on your MyPage. Meet other similar minded people. Its Free!


All Updates

A relational database management system uses SQL conditions or expressions in <tt>WHERE</tt> clauses and in <tt>HAVING</tt> clauses to <tt>SELECT</tt> subsets of data.

Types of condition

  • Many conditions compare values for (for example) equality, inequality or similarity.

to determine whether rows exist in a subquery result.


To <tt>SELECT</tt> one row of data from a table called tab with a primary key column (pk) set to 100 &mdash; use the condition pk = 100:

SELECT * FROM tab WHERE ''pk = 100''

To identify whether a table tab has rows of data with a duplicated key column dk set to 100 &mdash; use the condition dk = 100 and the condition having count(*) > 1:

SELECT * FROM tab WHERE ''dk = 100'' having count(*) > 1


Read More

No feeds found

Posting your question. Please wait!...

No updates available.
No messages found
Suggested Pages
Tell your friends >
about this page
 Create a new Page
for companies, colleges, celebrities or anything you like.Get updates on MyPage.
Create a new Page
 Find your friends
  Find friends on MyPage from