Condition (SQL)

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

X 

All Updates


Description:
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.

Examples

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




References






Read More

No feeds found

All
Posting your question. Please wait!...


No updates available.
No messages found
Suggested Pages
Zid
Zid
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