4
Reply

how to select top 7th and 10th marks from two tables

Khargesh Rajput

Khargesh Rajput

Jul 29 2013 6:42 AM
999
I have t1 table with roll and name  and table t2 have roll and marks.
now i have to select top of 7th marks in first row and top 10th marks in 2nd row and also remaining records will print after 3rd row.
what i have to do.
i have use join but i dont know how to use where and order by with join. and also how to select multiple queries to show the data simultanously

Answers (4)