JOIN
- Get link
- X
- Other Apps
- Get link
- X
- Other Apps
RANK FUNCTION
SIMPLE RANK FUNCTION: CREATE TABLE STUDENT ( S_ID NUMBER(10), S_NAME VARCHAR(30), TAMIL_MARKS NUMBER(10), ENGLISH_MARKS NUMBER(10), MATHS_MARKS NUMBER(10), SCIENCE_MARKS NUMBER(10), S_SCIENCE_MARKS NUMBER(10) ); INSERT INTO STUDENT VALUES(1,'PANDIAN',35,45,55,65,75); INSERT INTO STUDENT VALUES(2,'MUTHU',37,47,57,67,77); INSERT INTO STUDENT VALUES(3,'ASHOK',40,50,60,70,80); INSERT INTO STUDENT VALUES(4,'KUMAR',33,43,53,63,73); INSERT INTO STUDENT VALUES(5,'RANA',36,46,56,66,76); SELECT * FROM STUDENT; 1 PANDIAN 35 45 55 65 75 2 MUTHU 37 47 57 67 77 3 ASHOK 40 50 60 70 80 4 KUMAR 33 43 53 63 73 5 RANA 36 46 56 66 76 SELECT S_NAME,TOTAL,R...
Comments
Post a Comment