SQL Form

Now you can enter an arbitrary SQL-Query on our example database. Here are a few variations on the SELECT command that you might like to try:

• SELECT * FROM guestbook
• SELECT Guest_Name FROM guestbook ORDER BY Guest_Name
• SELECT DISTINCT Guest_Name, Email, Address FROM guestbook ORDER BY Guest_Name
• SELECT COUNT (*) FROM guestbook
• SELECT COUNT (*) FROM guestbook WHERE Country="USA"
• SELECT * FROM guestbook WHERE Guest_Name LIKE 'R%'

Watch how the Query Result changes depending on the form of the SELECT command that you enter.