Answer Posted / lekhraj deshmukh

select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;

What is not null in mysql?

1034

---

How many primary keys can be there in a table?

1030

---

How to create trigger in mysql phpmyadmin?

1180

---

Create table employee (eno int(2),ename varchar(10)) ?

1050

---

What is a scalar function?

1041

---

Why use mysql procedures?

1024

---

What does blob mean in mysql?

1011

---

Can you tell few best practices to be followed for optimization in sql?

973

---

How to show table structure mysql?

1057

---

What is the limitation of mysql?

1012

---

Is mongodb faster than mysql?

992

---

Why myisam is faster than innodb?

991

---

why not null is not allowed at table level

2807

---

How do I copy a table in mysql workbench?

937

---

Is mysql same as sql?

937

---