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

Answer / r

SELECT * FROM TABLE WHERE(rowid=N)

What are the 7 disadvantages to a manual system?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

What are scalar functions in sql?

0 Answers  

---

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

What do you know about system database? : SQL Server Architecture

0 Answers  

---

Explain transaction server explicit transaction?

0 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

---

What is recompile sql server?

0 Answers  

---

we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---