Answer / premanshu

if we have any table of employees and their salary
then the statement will be

select MAX(column_name) AS maxsalary
FROM table name

Answer / thakor ranvir

say for example one table employees
then issue below query .using agreegate function
select max(salary) from emlpoyees;

Answer / sk wazid hussain

select field_name from table_name order by field_name desc
limit 0,1

What is foreign key in mysql?

0 Answers  

---

How to get current MySQL version?

0 Answers  

---

Can not connect to mysql server 10060?

0 Answers  

---

What is the difference between primary and unique key

5 Answers   CSC,

---

What is the difference between CHAR and VARCHAR data types?

2 Answers   Ramco,

---

---

how to display nth highest salary from a table in a mysql query? : Mysql dba

0 Answers  

---

Is mysql free software?

0 Answers  

---

How can we know the number of days between two given dates using MySQL?

2 Answers   Base2 Infotech, Webworks,

---

How many TRIGGERS are allowed in MySql table?

0 Answers  

---

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

---

Is mysql better than oracle?

0 Answers  

---

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

0 Answers  

---