Answer / guest

select max(sal) from tab_name;
or
select * from tab_name where sal=(select max(sal) from
tab_name) and rownum<=1;

Answer / prashant

select max(salary) from
(select distinct(salary) from ABC)

What is exit statement?

0 Answers  

---

How to check if a column is nullable before setting to nullable?

0 Answers  

---

What does (+) mean in sql joins?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

Is pl sql a scripting language?

0 Answers  

---

---

What are the triggers associated with image items?

0 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

How to run pl sql program in mysql?

0 Answers  

---

Define sql delete statement.

0 Answers  

---