Results 1 to 2 of 2

Thread: SQL Server

  1. #1
    Ganeshag777 is offline Member
    Join Date
    Aug 2008
    Posts
    7
    Rep Power
    0

    Default SQL Server

    how can i find rowid in Sql server database as like in oracle.

  2. #2
    Join Date
    Jan 2009
    Posts
    14
    Rep Power
    0

    Default

    You can use row_number orderby one colums as below :

    select row_number() over
    (order by pk_idx_data_id) as rownum, empname,empsal from Employeetable

Similar Threads

  1. SQL server
    By elish11 in forum JDBC
    Replies: 2
    Last Post: 08-20-2008, 07:00 PM
  2. Does any file in an FTP server ends up in an HTTP server?
    By islamfunny in forum CLDC and MIDP
    Replies: 4
    Last Post: 08-15-2008, 05:30 PM
  3. Replies: 2
    Last Post: 07-15-2008, 07:11 PM
  4. One server to another server redirection
    By chaudhuri_abhi in forum Java Servlet
    Replies: 1
    Last Post: 02-11-2008, 08:05 PM
  5. WAS Server
    By Albert in forum Enterprise JavaBeans (EJB)
    Replies: 1
    Last Post: 06-25-2007, 06:38 AM

Posting Permissions

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