LIKE operator (SQL),”in SQL — allows you to select only rows that are “”like”” what you specify. The percent sign “”%”” can be used as a wild card to match any possible character that might appear before or after the characters specified. select first, last, city from empinfo where first LIKE ‘Er%’;// matches any name where first name begins with Erselect first

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.LIKE operator (SQL),”in SQL —[…]

Read more

Create table (SQL),”create table “”tablename””(“”column1″” “”data type””, “”column2″” “”data type””, “”column3″” “”data type””);ex. (see SQL data type card)create table employee(first varchar(15), last varchar(20), age number(3), address varchar(30), city varchar(20)

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Create table (SQL),”create table “”tablename””(“”column1″”[…]

Read more