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 index length in mysql?

0 Answers  

---

What?s the difference between query_cache_type 1 and 2?

1 Answers  

---

What are the steps required to view your mysql database?

0 Answers  

---

What are the applications required to support mysql?

0 Answers  

---

How you can create a trigger in mysql?

0 Answers  

---

---

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

0 Answers  

---

What are the different tables present in MySQL?

0 Answers  

---

How can we change the name of a column of a table?

7 Answers  

---

What are the technical features of MySQL?

0 Answers  

---

I want to find out all databases starting with ‘test’, I have access to?

0 Answers  

---

How do I find the size of a mysql database?

0 Answers  

---

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  

---