SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Select rows

  1. #1
    SitePoint Enthusiast
    Join Date
    Oct 2009
    Posts
    63
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Select rows

    Hi

    I have small doubt selecting rows from table.
    table is like this
    `id`,`name`,`date`,`price`,`total`
    we used to write query as

    Code:
    Select `id`,`name`,`date` from `table`
    Code:
    Select Top 3 from `table`
    for example
    i like 2 to select rows of first two columns without specifying its name.

    Thanks

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,495
    Mentioned
    161 Post(s)
    Tagged
    4 Thread(s)
    Quote Originally Posted by tomalex0 View Post
    Code:
    Select Top 3 from `table`
    Is this MySQL?
    for example
    i like 2 to select rows of first two columns without specifying its name.
    Without specifying the column names? You can't. Unless you use SELECT * which would select all columns.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •