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 substitution variable?

807

---

What is hibernate and its relation to sql?

804

---

Does sql require a server?

723

---

what are the t string functions available in tsql? : Transact sql

752

---

how to enter characters as hex numbers? : Sql dba

762

---

What is %type in sql?

706

---

Do ddl statements need commit?

730

---

Is sqlexception checked or unchecked?

729

---

What is cursor and why it is required?

815

---

How do I run a pl sql procedure in sql developer?

703

---

What is view? Can we update view

1096

---

What are types of exception?

702

---

Explain isolation levels. : Transact sql

759

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

770

---

How do you use join?

710

---