SELECT * FROM TABLE WHERE(rowid=N)

how to dispaly a particular row details from a given table

Question Posted / r

Answer Posted / r

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Write a program to fetch first 10 records from a file?

1063

How to replace the Query Result 'Null Value' with a text ?

1095

What is the server name in sql server?

1068

What is difference between table aliases and column aliases? Do they affect performance?

1021

How can I change procedure name in sql server?

1113

How to transfer data from a cursor to variables with a "fetch" statement?

1145

When to use Inner join & when to use subquery?

1238

What is the maximum size of a row in sql server?

1006

To which devices can a backup be created and where should these devices be located? : sql server management studio

1102

What is ddl and dml commands?

959

How can we determine what objects a user-defined function depends upon?

1075

What do you mean by table and field in sql?

1065

List out the differences between the clustered index and non-clustered index in sql server?

1052

What is user-defined functions? What are the types of user-defined functions that can be created?

1081

What is change data capture (cdc) in sql server 2008?

1080