TCS Xplore Solutions

Search This Blog

Python OPA Unix code (28/08/20)

on August 28, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

read

tr ":" "|" | awk 'BEGIN{FS="|";}{print $1,$2,$3*60+$4}'

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Java OPA code

Java Code Copy from below import java.util.Arrays; import java.util.Scanner; public class Solution { public static void main ( String [] args ) { Scanner sc = new Scanner ( System . in ); Item [] itms = new Item [ 4 ]; for ( int i = 0 ;i< 4 ;i++){ int itemId = sc . nextInt (); sc . nextLine (); String itemName = sc . nextLine (); String itemType =...

Python MySql Hands On

Hands On 1 select d.deptname,count(*) from Employees e inner join Departments d on d.deptid=e.deptid group by e.deptid , d.deptname Hands On 2 select i.itemname from items i inner join orders o on i.itemid=o.itemid and o.orderid=4499 Hands On 3 select ename from employees where deptid = (select deptid from employees where eid=108)

Java OPA UNIX Code

Unix Code Please change variable names tr '/' ';' | tr '-' ';' |awk 'BEGIN{FS=";"} { if($2 == 01) { sum = $5+sum; c += 1; } } END{ if(c>0) print sum+c*100; else print 0; } java code

Powered by Blogger

Python OPA Unix code (28/08/20)

Comments

Post a Comment