re: SQL 101: Five SQL Server Tips VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Great set of pointers - thanks for the write-up, Helen! I especially like your SELECT TOP 0 table creation trick. Is any of this specific to cert...
 

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

 
 

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?

code of conduct - report abuse