Answer / lakshmi

select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));

Answer / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

how to find out largest value in a table

2 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers  

---

what is unique key?

14 Answers   Amazon, Cap Gemini, Infosys, Wipro,

---

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

---

Is rowid unique in oracle?

0 Answers  

---

---

How to loop through a cursor variable?

0 Answers  

---

1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,

---

Design database draw er diagram for a certain scenario ?

0 Answers   Keane India Ltd, TATA,

---

In oracle there is column command, how will you explain that?

0 Answers   Aricent,

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

How can you use check constraints for self referential integrity?

0 Answers  

---

What are the predefined tablespaces in a database?

0 Answers  

---