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)

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

How to copy the tables, schema and views from one sql server to another?

0 Answers  

---

What is a fill factor?

0 Answers  

---

Tell me what are cursors and when they are useful?

0 Answers  

---

How do I run sql server 2014?

0 Answers  

---

What is nested transaction?

0 Answers  

---

What does the not null constraint do?

0 Answers  

---

What do you understand by the denormalisation?

0 Answers  

---

How to perform backup for certificates in sql server? : sql server security

0 Answers  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

What is the benefit of normalization?

0 Answers  

---

what are the types of indexes? : Sql server database administration

0 Answers  

---