Answer Posted / sarojkant

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Can we change the table name in sql?

1000

---

Write a sql query to find the names of employees that begin with ‘a’?

1057

---

What is sql and how does it work?

1248

---

Can you sum a count in sql?

1059

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1116

---

How do you create a db file?

1067

---

what are the 'mysql' command line options? : Sql dba

1133

---

What is a table in a database?

1094

---

What is a boolean in sql?

1025

---

how can we know the number of days between two given dates using mysql? : Sql dba

1083

---

Explain 3 basic parts of a trigger.

1373

---

Explain the advantages and disadvantages of stored procedure?

1198

---

Enlist some predefined exceptions?

1111

---

How is pl sql different from sql?

1142

---

How is sql used in oracle?

1037

---