Profile cover photo
Profile photo
Siyaram Vishwakarma
42 followers
42 followers
About
Siyaram Vishwakarma's posts

Post has attachment
Hi Friends,
We developed a new website www.classicaldeal.com, which will bring you latest deals/coupons/offers/promocodes.
Like us at https://www.facebook.com/classicaldeal
Contact us at classicaldeal@gmail.com

Regards
Team ClassicalDeal.com

Post has attachment
How to find n-k th row from a table in SQL
Refer table  click here  for this post. if table emp has n rows then to display n-kth row we need to run the following command

Post has attachment
SQL: how to display nth record from table
To display n th row from a table say Emp:  select * from Emp where rownum< (n+1) MINUS   select * from Emp where rownum < n First select query will return first N rows and second
select query will return first N-1 rows and then subtract these two results wh...

Post has attachment
how to select duplicate records in sql
First we do grouping of all the records in the table then display only those records whose count is greater than 1. For more more details see the Emp table and Output result Query: Select sal from emp group by sal having count(sal) > 1 Displays all the sala...

Post has attachment
How to multiply columns in sql
Temp is a table containing number as column name and if you want to multiply all the values in number column..then simply run the following command. Select exp(sum(ln(number))) from Temp; Example: Number 1 2 3 exp(sum(ln(Number))) = exp(ln1+ln2+ln3) = exp(l...

Post has attachment
How to delete duplicate records in sql
Delete from Student a1 where a1.rowid < (select max(rowid) from Student a2 where a2.name=a1.name); Explaination: For each row in Outer query, inner query runs for complete table checking the equal condition and returns maximum row id and if this maximum row...

Post has attachment
Ads not by this site
This has been very popular way to advertisement for this when you install any software using down loader after successfully installation DefaultTab.exe  gets downloaded and installed. you do not need to do anything even "next click". so people are unware of...

Post has attachment

Post has attachment

Post has attachment
Wait while more posts are being loaded