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)

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---

Can there be more than one function with a similar name in a pl/sql block?

0 Answers  

---

Can we use pl sql in mysql?

0 Answers  

---

Explain 3 basic parts of a trigger.

0 Answers  

---

What is oracle pl sql developer?

0 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

How do sql triggers work?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

what is switch column,colums cost in oracle?

0 Answers   Metric Stream,

---

What is trigger with example?

0 Answers  

---