Answer Posted / akki julak

FOR EXAMPLE WE HAD TAKE EMP TABLE AND ENAME,EMPNO AS COLUMNS

SELECT EMPNO,ENAME
FROM EMP
WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME);


by
AKKI JULAKANTI

What is your daily office routine?

2256

---

How can you know that statistics should be updated?

1064

---

What are the different ways to optimize a sql query?

929

---

Mention what does plv msg allows you to do?

1097

---

What is replication id?

922

---

What is the most common sql injection tool?

1027

---

What is linq to sql?

1121

---

What is not equal in sql?

1088

---

What is cartesian join in sql?

1097

---

what is unique key constraint? : Sql dba

1022

---

Which tcp/ip port does sql server run?

989

---

Differentiate pl/sql and sql?

1052

---

Which is better join or subquery?

1120

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2007

---

What is composite primary key in sql?

982

---