DEV Community

[Comment from a deleted post]
Collapse
 
arj profile image
arj

Especially SELECT TOP 0 is Microsoft SQL server specific. The other commands looked like they are ANSI SQL.

Collapse
 
hoelzro profile image
Rob Hoelz

Ok, TOP was what I was wondering about - thanks!

Collapse
 
gunathirumal profile image
Gunaseelan Thirumal

I am using oracle. Can use select * from table where 1<>1 to create a empty table of this format? Or any other specific query available to select no records like TOP in Microsoft SQL?