I have a table called "Details" in that i have records , like
uid name level
1 a 1
2 b 1
3 c 1
4 d 1
5 e 2
6 f 2
7 g 2
8 h 3
9 i 3
10 j 3
I want to get only 2 records that have level 1 , and all the rest of the records. like
uid name level
1 a 1
2 b 1
5 e 2
6 f 2
7 g 2
8 h 3
9 i 3
10 j 3
I dont want the TOP 8 records, only 2 records from specific level, and rest all of the records from other levels should be retrieved as well.