Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

db3

Language: Layout:
View schema
Execution time: 0,03 sec, rows selected: 44, rows affected: 26, absolute service time: 0,25 sec, absolute service time: 0,25 sec 
latest |  history
   sql server version
1 Microsoft SQL Server 2014 - 12.0.2000.8 (Intel X86) Feb 20 2014 19:20:46 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
   dept_id name hod location
1 1 Civil Arun civilblock
2 2 Electrical Karpaga Electricalblock
3 3 Electronics valli Electronicsblock
4 4 Computer Saravana Computerblock
5 5 Mechanical Kavin Mechanicalblock
   rollno name dept_id mobile addr
1 101 Siva 3 9678909867 chennai
2 102 deepa 2 9673409867 madurai
3 103 Anand 5 9988909867 chennai
4 104 arjun 4 9611409867 theni
5 105 deepak 1 9678999867 trichy
6 106 deepa 2 9677409867 vilupuram
7 107 Sangeetha 2 9777909867 chennai
8 108 rajesh 2 9673433367 karaikal
9 109 kalai 4 9674545867 chennai
10 110 selvi 1 9860409867 madurai
   rollno name dept_id mobile addr
1 101 Siva 3 9678909867 chennai
2 102 deepa 2 9673409867 madurai
3 103 Anand 5 9988909867 chennai
4 104 arjun 4 9611409867 theni
5 105 deepak 1 9678999867 trichy
6 106 leela 2 9677409867 vilupuram
7 107 Sangeetha 2 9777909867 chennai
8 108 rajesh 2 9673433367 karaikal
9 109 kalai 4 9674545867 chennai
10 110 selvi 1 9860409867 madurai
   rollno name dept_id mobile addr
1 101 Siva 3 9678909867 chennai
2 102 deepa 2 9673409867 madurai
3 103 Anand 5 9988909867 chennai
4 104 arjun 4 9611409867 theni
5 105 deepak 1 9678999867 trichy
6 106 leela 2 9677409867 vilupuram
7 107 Sangeetha 2 9777909867 chennai
8 108 rajesh 2 9673433367 karaikal
9 110 selvi 1 9860409867 madurai
   rollno marks
1 101 82
2 102 84
3 103 85
4 104 86
5 105 88
6 106 95
7 107 98
8 108 55
9 110 50