By 08/02/2016 6 Comments

SELECT * vs SELECT column names in SQL

  • SELECT * and SELECT column names both are valid statements in SQL.
  • SELECT column names retrieve only desired columns from database table(s), at the other hand SELECT * retrieves all columns.
  • Finally SELECT column names is much faster than SELECT *.

Example:

SELECT city_name, city_code
FROM tble_city;






Posted in: Solutions

Leave your valuable Comment

Have a natural attraction for women cosmetics and replica watches uk clothes, no
more than two for men the most attractive one, is to make their own driving experience, happy and can serve as the facade of the car, another is to highlight the taste edify sentiment rolex replica watch. The replica rolex is undoubtedly the most fashionable accessories, wear a suit to attend the activities, but also get a decent match on the replica watches .