need a sql to get the tourist who paid maximum amount in single booking
2789
Fetch the row which has the Max value for a column
39628
SQL select only rows with max value on a column
2374
How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
12037
Remove duplicate values from query result
46339
How do I compare 2 rows from the same table (SQL Server)?
121738
How to find the nth highest salary in SQL?
13134
MySQL select SUM of results with a LIMIT
15342
Biggest possible double/float for a column in my MySQL database
18269
SQL MAX of multiple columns?
108056
Returning a result set with multiple rows based on max date
127084
Returning the 'last' row of each 'group by' in MySQL
120734
How to get Total Pupulation From Tables In Sqlserver?
38470
Subquery returns more than 1 row SQL
68780
Limit on the WHERE col IN (...) condition
45017
Is it possible to move a record from one table to another using a single SQL statement?
16123
How to find rows that have maximum value?
22026
Single SQL query required