query to fetch the highest record in a table

Home Answers Viewqa SQL query to fetch the highest record in a table

QuestionAsk Questions?

hemant kumar

query to fetch the highest record in a table
1 Answer(s) 2 years and 7 months ago
Posted in : SQL

Write a query to fetch the highest record in a table, based on a record, say salary field in the empsalary table

View Answers

November 19, 2010 at 5:39 PM

Hi,

The query string to fetch the highest record from a table is -

Select max(salary) from empsalary;

Thanks,

query to fetch the highest record in a table
query to fetch the highest record in a table Write a query to fetch the highest record in a table, based on a record, say salary field in the empsalary table

fetch record from MYsql table query
fetch record from MYsql table query Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table

JDBC : Find Highest salary
JDBC : Find Highest salary In this tutorial, we are showing how to find record of highest salary employee. MAX() : MAX() method returns the highest... are displaying record of such employee who has highest salary among all. For that we

Write a query to insert a record into a table
Write a query to insert a record into a table Write a query to insert a record into a table Hi, The query string is as follows- Insert into employee values ('35','gyan','singh'); Thanks

MySql Databse query to fetch results from database
MySql Databse query to fetch results from database Hi. I have... chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values

JDBC : Find Third highest salary
record of employee having second highest salary. Find Third highest salary... to find out third highest salary so you can write different logical query to get third highest salary. Employee Table : - Example

JDBC : Find second highest salary
record of employee having second highest salary. Find second highest salary... to find out second highest salary so you can write different logical query to get second highest salary. Employee Table : - Example

Write a query to delete a record from a table
Write a query to delete a record from a table Write a query to delete a record from a table Hi, The query string for the delete operation is as follows- delete from employee where id='35'; Thanks

Edit the record.
Edit the record. sir, I have a table consist of huge data.I have... to previous edited row or edit the previous record of the previously edited... or some email.according to the sorted page we should fetch the data and edit

MySql Databse query to fetch results from database and display it in HTML File
MySql Databse query to fetch results from database and display it in HTML...(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma

JDBC Fetch
call execute Query ( ),The method is used to fetch the record set from... JDBC Fetch The Tutorial describe you a code that fetch the elements from a database. In this Tutorial

mysql_fetch_object and mysql_fetch_array.
mysql_fetch_object and mysql_fetch_array. What is the difference between mysqlfetchobject and mysqlfetcharray? Hi friends, MySQL fetch object will collect first single matching record where mysqlfetcharray

Fetch user records from a table in database
Fetch user records from a table in database Hi. I have a field...,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values

JDBC Select Record Example
JDBC Select Record Example In this tutorial we will learn how select specific record from table use mysql JDBC driver. This select...; use the another condition i.e user_name="User1" then fetch

query
query how to delete checked record into database using checkbox in jsp We are providing you the code where we have specified only three..."> <table border="1"> <tr><td></td> <td><b>

Mysql Last Record
in set (0.00 sec) Query to view last record of Table named...; Query to Create Table named employee1... -> ); Query to insert records or rows in Table named

how to fetch the record using AJAX? - Ajax
how to fetch the record using AJAX? Can anyone tell me how to fetch the records from database using Ajax

3rd&5th highest salary from a table
3rd&5th highest salary from a table how we get 3rd highest and 5th highest salary from a table

data insertion and fetch 1
data insertion and fetch 1 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ <...;table border="2"> <th>Name</th>...; } @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@222 how to fetch

JSP Delete Record From Table Using MySQL
JSP Delete Record From Table Using MySQL This tutorial explains you that how to write a JSP for deleting a record from database table. In this section you will see all the steps required for deleting a record of a table

Mysql Last Record
in set (0.00 sec) Query to view last record of Table named...; Mysql Last Record is used to return the last records from table... an example from 'Mysql Last Record'. To understand example we create a table

retrieve record from table
retrieve record from table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually

Query Question
Query Question How would I write a query to display the name, department of the employee that earns the highest salary in the Employees table

PHP SQL Fetch
PHP SQL Fetch PHP SQL Fetch is used to fetch the records from Mysql database to PHP... The Tutorial illustrate an example from PHP SQL Fetch. To understand and grasp

MySQL PHP Query delete
( ) delete query from a database table. MySQL PHP Query is used to delete the records... on 'MySQL PHP Query delete'. To understand the example we create a table 'MyTable... (0.00 sec)` Query to view data inserted in table

MySQL PHP Query delete
( ) delete query from a database table. MySQL PHP Query is used to delete the records... PHP Query delete'. To understand the example we create a table 'MyTable...) Query for inserting data in table: To add the records or rows to the table

PDO Fetch Execute
($sql); $result=$stmt->fetch(PDO::FETCH_ASSOC); echo "<table border...PDO Fetch Mode: We have studied before in the earlier tutorials that how to connect with a database and how to fetch data from the tables, in many times we

fetch record from oracle database using jsp-servlet?
fetch record from oracle database using jsp-servlet? how can i fetch data from oracle database by using jsp-servlet. i'm using eclipse, tomcat server and oracle database and creating jsp pages and also using servlet

PDO Fetch Num
;query($sql); $result=$stmt->fetch(PDO::FETCH_NUM); echo "<table...PDO Fetch Num: We've discussed in the previous tutorial about PDO::FETCH... index of the result unlike the PDO::FETCH_ASSOC which returns the name

PDO Fetch Object
PDO Fetch Object: This is another way to access the data of a table...;query($sql); $obj=$stmt->fetch(PDO::FETCH_OBJ); echo $obj->name."... as anonymous object and this object represents the field names of the table as object

how to set fetch size for jdbc odbc driver
table then set fetch size. JDBC ODBC Fetch Example package roseindia.net...how to set fetch size for jdbc odbc driver What is the default fetch size for the JDBC ODBC driver and how can i fetch a set of results for JDBC

Hibernate Delete Query
In this section we will discuss how to delete record of table using HQL

PDO Fetch Both
;fetch(PDO::FETCH_BOTH); echo "<table border=1>"; foreach...PDO Fetch Both: In the previous two examples we have seen the two methods... type), PDO provides the solution as PDO::FETCH_BOTH produces, with the help

retrieve record from the field table
retrieve record from the field table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table

How to retrieve record from table
How to retrieve record from table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data from the field table

Mysql Minimum Query
record from table. Understand with Example The Tutorial makes you understand...; Query to Create Table named employee1: mysql>... -> ); Query to insert data into Table named employee1: Once your

PDO Fetch Class
PDO Fetch Class: Using PDO::FETCH_CLASS we can map the fields of a table... * from emp_details"; $stmt=$dbh->query($sql); $obj=$stmt->fetchALL(PDO::FETCH_CLASS,'employee'); foreach($obj as $emp){ echo $emp

Data fetch from multiple SQL tables - Hibernate
Data fetch from multiple SQL tables I am in the process of writing my first hibernate application. I have a sql query that fetches data from... keys. I have created hibernate mapping for each table, datasource

JDBC Insert Record
is processed. Finally the execute Query ( ) return you the record set from a table... JDBC Insert Record ... Record. In this code we have a class JdbcInsertRecord.Inside this class

fetch values from database into text field
fetch values from database into text field please provide the example for fetching values from database into text field of table wth edit and delete option on each row as if i am trying following String query = "select

fetch values from database into text field
fetch values from database into text field please provide the example for fetching values from database into text field of table as if i am trying following String query = "select * from LTCINFO.PERSONS"; st1

Mysql Table
delete is used to execute Mysql function ( ) delete query from a database table. MySQL PHP Query is used to delete the records from the table 'MyTable' based... Mysql Table

delete record
delete record how to delete record using checkbox and button in php We are providing you the jsp code that displays the database table data into the html table. Along each table row there is a checkbox consists

query
query Sir this is table code. i created successfully ,but i want to get table data.so could you please help me for this problem.Thank you sir import... javax.swing.event.*; import java.awt.event.*; import java.awt.print.*; public class table extends

query
query Create the following tables and insert 3 appropriate records in each table: Employee(empid, empname, empstreet, empcity) Works(empid, companyid, salary) Locatedin(companycode, compname, compcity) Find the name of all

retrieve record from table and show it in HTML
retrieve record from table and show it in HTML Hi. I have a field...,trichy,kanchipuram for a single record. I have to retrieve these data from the field table. Actually they are separated by comma. I want to take the values

Latest
Frameworks
Category