how to dispaly a particular row details from a given table

Answers were Sorted based on User's Feedback



how to dispaly a particular row details from a given table..

Answer / karthick.r

the query to display a particular record for the emp'v4290'
is given below

select * from employee where empid="v4290";

in this eg employee is the table-name and v4290 is the value
for the attribute empid. where is the clause to fetch the
record from the backend database table

Is This Answer Correct ?    3 Yes 0 No

how to dispaly a particular row details from a given table..

Answer / r

SELECT * FROM TABLE WHERE(rowid=N)

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL Server Interview Questions

How to restore performance issues and how to check?

0 Answers  


How to insert multiple rows with a subquery?

0 Answers  


Explain cross join or cartesian product in sql?

0 Answers  


How to run sql server 2005 books online on your local system?

0 Answers  


What is the Disadvantage of indexed sequential file.

0 Answers   HCL,






How do you check sql server is up and running?

0 Answers  


How to create a trigger for insert only?

0 Answers  


How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,


How can sql injection be stopped? : sql server security

0 Answers  


can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  


What are functions in the sql server?

0 Answers  


What are the encryption mechanisms in sql server?

0 Answers  


Categories