Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

ok

Language: Editor: Layout:
View schema
Execution time: 0,02 sec, rows selected: 53, rows affected: 20, absolute service time: 0,23 sec, absolute service time: 0,24 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)
   emp_id employee name hire date salary
1 1 hsdjnsdn 12.01.2018 00:00:00 40000
2 2 oofnsj 10.02.2018 00:00:00 80000
3 3 gijdf 01.03.2018 00:00:00 20000
4 4 Mqedcdr 22.04.2018 00:00:00 70000
5 50 adqwd 01.05.2018 00:00:00 10000
6 6 asqddf 23.06.2018 00:00:00 60000
7 70 asdwew 29.07.2018 00:00:00 50000
8 80 qwert 12.08.2018 00:00:00 40000
9 9 Mazsxd 30.03.2018 00:00:00 20000
10 10 ascdwe 02.02.2018 00:00:00 30000
   emp_id employee name hire date salary
1 1 hsdjnsdn 12.01.2018 00:00:00 40000
2 2 oofnsj 10.02.2018 00:00:00 80000
3 3 gijdf 01.03.2018 00:00:00 20000
4 4 Mqedcdr 22.04.2018 00:00:00 70000
5 50 adqwd 01.05.2018 00:00:00 10000
6 6 asqddf 23.06.2018 00:00:00 60000
7 70 asdwew 29.07.2018 00:00:00 50000
8 80 qwert 12.08.2018 00:00:00 40000
9 9 Mazsxd 30.03.2018 00:00:00 20000
10 10 ascdwe 02.02.2018 00:00:00 30000
   id employee name cost
1 1 hsdjnsdn 40000
2 2 oofnsj 80000
3 3 gijdf 20000
4 4 Mqedcdr 70000
5 5 adqwd 10000
6 6 asqddf 60000
7 70 asdwew 50000
8 8 qwert 40000
9 9 Mazsxd 20000
10 10 ascdwe 30000
   emp_id emp_name DOJ_date salary
1 4 Mqedcdr 22.04.2018 00:00:00 70000
2 9 Mazsxd 30.03.2018 00:00:00 20000
   Hire date
1 12/01/2018
2 10/02/2018
3 01/03/2018
4 22/04/2018
5 01/05/2018
6 23/06/2018
7 29/07/2018
8 12/08/2018
9 30/03/2018
10 02/02/2018
   DOJ US_currency UK_Currency
1 01/05/2018 $10,000.00 £10,000.00
2 02/02/2018 $30,000.00 £30,000.00
3 29/07/2018 $50,000.00 £50,000.00
4 23/06/2018 $60,000.00 £60,000.00
5 01/03/2018 $20,000.00 £20,000.00
6 12/01/2018 $40,000.00 £40,000.00
7 30/03/2018 $20,000.00 £20,000.00
8 22/04/2018 $70,000.00 £70,000.00
9 10/02/2018 $80,000.00 £80,000.00
10 12/08/2018 $40,000.00 £40,000.00