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

Can we store videos inside the sql server table?

0 Answers  


What is the difference between varchar and nvarchar types?

1 Answers  


What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,


What is temporal table?

0 Answers  


How we can refresh the view?

0 Answers  






What are the two authentication modes in sql server?

0 Answers  


What are the differences between decimal and float in ms sql server?

0 Answers  


What is dbcc?

0 Answers  


what is a join and explain different types of joins? : Sql server database administration

0 Answers  


How do I find the port number for sql server?

0 Answers  


Difference between report and query parameter.

0 Answers  


After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,


Categories