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

mysql4

Language: Layout:
View schema
Execution time: 0,05 sec, rows selected: 36, rows affected: 17, absolute service time: 0,25 sec, absolute service time: 0,25 sec 
edit mode |  history  | discussion
   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)
   Id Name salary mobile designation
1 1 BHARTI 22700 70114 helpdesk
2 2 MUKESH 22700 81300 helpdesk
3 3 NEHA 28600 81307 helpdesk
4 4 VISHAL 28600 96677 helpdesk
5 5 SONU 28600 96508 helpdesk
   Id Name salary mobile designation
1 1 VIKRANT 40000 12356 TESTER
2 2 KARAN 45000 12353 TESTER
3 3 RAJNISH 45000 12359 TESTER
4 4 GOURAV 42000 12351 TESTER
5 5 JEETESH 43000 12369 TESTER
   Id Name salary mobile designation EMAIL
1 1 VIKRANT 40000 12356 TESTER NULL
2 2 KARAN 45000 12353 TESTER NULL
3 3 RAJNISH 45000 12359 TESTER NULL
4 4 GOURAV 42000 12351 TESTER NULL
5 5 JEETESH 43000 12369 TESTER NULL
   Id Name salary mobile designation EMAIL
1 1 VIKRANT 40000 12356 TESTER VIKI
2 2 KARAN 45000 12353 TESTER NULL
3 3 RAJNISH 45000 12359 TESTER VIKI
4 4 GOURAV 42000 12351 TESTER NULL
5 5 JEETESH 43000 12369 TESTER NULL
   EADD
1 2
   Id Name salary mobile designation
1 1 BHARTI 22700 70114 helpdesk
2 2 MUKESH 22700 81300 helpdesk
   LOWESTSALARY
1 40000
   MAXSALARY
1 28600
   Id Name contact blood_group join_date
1 1 SONU 35467 O+ 8_JUNE
2 2 VISHAL 794873 A+ 8_JUNE
3 3 NEHA 8342 B+ 8_JUNE
4 4 MUKESH 22634 A- 8_JUNE
5 5 BHARTI 2823749 AB+ 8_JUNE
   Name blood_group salary join_date designation mobile contact
1 BHARTI AB+ 22700 8_JUNE helpdesk 70114 2823749
2 MUKESH A- 22700 8_JUNE helpdesk 81300 22634
3 NEHA B+ 28600 8_JUNE helpdesk 81307 8342
4 VISHAL A+ 28600 8_JUNE helpdesk 96677 794873
5 SONU O+ 28600 8_JUNE helpdesk 96508 35467

    
                
stackse - search stackoverflow differently