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 procedural api?

0 Answers  

---

How much does mysql enterprise cost?

0 Answers  

---

How to convert character strings to dates?

0 Answers  

---

How many triggers are possible in mysql?

0 Answers  

---

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

---

---

What is 'mysqld'?

0 Answers  

---

How do I export mysql query results to excel?

0 Answers  

---

How many columns can be used for creating Index?

0 Answers  

---

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  

---

What are the differences between char and varchar?

0 Answers  

---

How do I free up space in mysql?

0 Answers  

---

How to get data from mysql in php?

0 Answers  

---