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 are the purposes of using enum and set data types?

0 Answers  

---

What are the functions used to encrypt and decrypt the data present in mysql?

0 Answers  

---

What is the full meaning of mysql?

0 Answers  

---

How do I transfer data from one database to another in mysql?

0 Answers  

---

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  

---

What is the use of i-am-a-dummy flag in mysql?

0 Answers  

---

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  

---

Which statement is used in a select query for partial matching?

0 Answers  

---

How can I create table in mysql?

0 Answers  

---

How do we delete a row in a table?

0 Answers  

---

How do I install mysql?

0 Answers  

---

How can we get the number of rows affected by query?

0 Answers  

---