Answer Posted / guest

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

How to add, remove, modify users using sql?

744

---

How does a self join work?

693

---

What are the triggers associated with image items?

794

---

Where not exists in sql?

675

---

how to run 'mysql' commands from a batch file? : Sql dba

777

---

---

Differentiate between pl/sql and sql?

806

---

What is Difference Between Unique and Primary Key Constraints?

827

---

What are the different parts of a package?

812

---

What is the difference between microsoft access and sql server?

713

---

How do you delete duplicates in sql query using rowid?

720

---

what is the difference between undefined value and null value? : Sql dba

783

---

What has stored procedures in sql?

783

---

What does the argument [or replace] do?

807

---

How to get list of all tables from a database?

842

---

How to write html code in pl sql?

804

---