Answer Posted / nishant dubey

Table join itself using alias..
example
Select N,emp_id,N.emp_name,D.emp_id,D.emp_name from Nishant
N,Nishant D where N.emp_id=D.emp_id;

What are the types of database model?

1030

---

What is dbms and its application?

948

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1977

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2163

---

Explain about network model?

952

---

Who are naive users?

956

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2374

---

Explain the rollup operator?

999

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

952

---

What is a database development?

912

---

How to read and create .LDC data files which are used by linguatic dictionary.

2479

---

How can you log an error to the server event log from a stored procedure?

1040

---

Explain the process of the user request and data generating?

1042

---

Explain about query and reporting.

2032

---

How would you design a database for an online site, which would average a million hits a day?

951

---